exceltoxl.com

Hi there,

This complete week, we will learn about few inner techniques of Pivot Table. These are few of my learnings in near days so thought of sharing to power your skills on Pivot. In my previous post, I spoke about How Human Parts Resembles Excel Features where Pivot is compared with Kidney. So, we will do some cleansing to our Kidney. :)

In this week we will learn about:

1. Adding few points to a Simple Pivot Table

2. Group data from months and years

3. Grouping data for words

4. About GETPIVOTDATA and its Advantages

5. How to avoid displaying the removed items in the pivot table

...

ADDING FEW POINTS TO A SIMPLE PIVOT TABLE: 

In the previous post, we have seen PIVOT TABLE - TUTORIAL (Basic) and to add few points to it,

1. To add fields into ROW Labels just need to check mark the items in the "Choose Fields to add to report", it automatically adds to the ROW labels as default.

2. To add fields into ∑ Values just need to check mark the items in the "Choose Fields to add to report", it automatically adds to the or ∑ Values as default, 

3. Point to be Noted: Make sure the first point work only if the column doesnot have values similarly the second point works when the column has values. 

4. To remove fields from the table just need to uncheck from "Choose Fields to add to report".

5. By default, pivot will take the sum of values when we drop the value column into ∑ Values. But to find the count ,max, min, average, product, stddev, var just click on down arrow and select "Value Field Settings" and click OK. Click on "Summarize By" tab and choose the above type of calculations.

6. To customize column headings in the pivot, double click on the column header and customize accordingly and then click oK.

DO YOU USE PIVOT?

Have you learnt something out of these episodes? Want to share anything with us. Use this space and post your valuable ideas or suggestions using the below comments section.

If you like this post, please do share it on your social networking sites just by one click on the icons placed around the blog.

If you want to support me for maintaining this blog, please do REGISTER here for free. 

Thanks,