Pivot Tip 4 - Drill down on your data via Hide/Show Detail. by David Carter
David Carter's series of Five Minute tips aims to develop your skill at using Excel pivot tables. If you want to test the tip for yourself, David takes you through a worked example on the practice database.
Pivot Tip #4 ' Use Hide Detail and Show Detail to drill down on your data
A pivot table can summarise thousands of records into just a couple of lines. To drill up or down between totals and transactions use the Hide Detail and Show Detail options from the pivot table menu.