I am working a spreadsheet that totals for certain categories. Frequently it
is necessary to see the detail that made up that figure. Right now I am using
comments but this laborious. I'm not sure if pivot tables are what I need or
not.
Basically I have a total and would like to mouse over or something and go to
a different chart/page to see the breakdown.