1014 Pivot Table - Drill Down Option

0 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  A$195.60
You save:  A$55.89
List Price:  ৳11,872.36
You save:  ৳3,392.34
List Price:  CA$187.37
You save:  CA$53.54
CHF 91.26
List Price:  CHF 127.77
You save:  CHF 36.51
List Price:  kr884.75
You save:  kr252.80
List Price:  €118.74
You save:  €33.93
List Price:  £107.27
You save:  £30.65
List Price:  HK$1,084.99
You save:  HK$310.02
List Price:  ₹10,502.85
You save:  ₹3,001.03
List Price:  RM586.20
You save:  RM167.50
List Price:  ₦52,986.21
You save:  ₦15,140
List Price:  kr1,265.84
You save:  kr361.69
List Price:  NZ$211.96
You save:  NZ$60.56
List Price:  ₱6,870.27
You save:  ₱1,963.07
List Price:  ₨23,504.32
You save:  ₨6,716
List Price:  S$192.17
You save:  S$54.91
List Price:  ฿4,370.86
You save:  ฿1,248.90
List Price:  ₺1,021.10
You save:  ₺291.76
List Price:  R2,469.09
You save:  R705.50
Already have an account? Log In


Hi there. This time, I'm going to show a small trick which allows you to get into the deeper details of the pivot table you are working with. For example, you may have made a pivot table which shows the eight divisions and the number of people working within those divisions. Now, if you happen to pick in data or mathematical number from the main action area or value field, and if you double click on that, what you notice is it generates a new sheet in which the details are residing. So for example, since I clicked on this number, which is falling under CFD, in the new sheet, what I noticed is all these employees with the list of which code generated are showing that they are all from CD f d. So this is like a report on demand a drill down report. So if you double click on any number in the main action area, that's the value field, you will get this in a new sheet, the breakup of the entire set of numbers.

So there you go. This was another trick which allows you to get into deeper details of pivot table data.

Sign Up