Excel 2016 - PivotTable Drill Down / Drill Up Tool

Question

_{Thursday, June 16, 2016 8:23 PM}

Just trying to figure out what these tools are used for?

They appear greyed out.

I know how to drill down data within a PivotTable by double-clicking a total but it appears the Drill Down tool has maybe got some other purpose but I'm not sure.

All replies (2)

_{Friday, June 17, 2016 9:17 AM}

Hi,

Did you want to know how to use this option as shown in the following figure?

If yes, I suggest you refer to this support article to get more information:

https://support.office.com/en-us/article/Drill-into-PivotTable-data-c1b11240-fc8f-4fdd-a697-629bf6f7ee0b

If my understanding is incorrect, please provide more information and I'm glad to help you.

Regards,

Emi Zhang
TechNet Community Support

Please mark the reply as an answer if you find it is helpful.

If you have feedback for TechNet Support, contact [email protected].

_{Saturday, June 18, 2016 9:42 AM}

Hi there,

Thanks for this - I'm assuming these instructions also relate to Excel 2016.

If so it appears that the Drill Down and Drill Up tools will only be available if the using an advanced PivotTables (ie Online Analytical Processing (OLAP) cube or Data Model-based PivotTable hierarchy).