What are the in-depth reasons for using Drilling in an Excel worksheet? Please give examples so I can comprehend.

Hi Eckard2012,

I do not know whether these links are helpful to you, you can refer to these links first:

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

http://www.thecompanyrocks.com/how-to-drill-down-in-a-pivot-table-to-display-the-details-for-a-summary-cell/

https://www.youtube.com/watch?v=frCX7t2xhnY

http://datapigtechnologies.com/blog/index.php/be-careful-drilling-into-pivottables-with-slicers/

http://www.contextures.com/excel-pivot-table-drilldown.html

If you need more in-depth about this function, please let me know and could you be at bit more precise explain your need. I am glad to help and forward to your reply.

Regards,