Looking for a macro that will create a pivot table grand total drill down on a separate tab.
example attached
Looking for a macro that will create a pivot table grand total drill down on a separate tab.
example attached
Double clicking anything in the pivot table will give you the records that went into that calculation.
We could write a macro to find the Grand Total field and show detail, but that would be more inconvenient than just double clicking unless you need this as part of some bigger automated procedure.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Yes this is apart of a several step procedure.
I need the results of the red box on sheet1 to be shown on the drilldown tab.
Today there are 11 rows on sheet 1 tomorrow there could be 20.
found the solution...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks