Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get grand total from pivot table
Hello All,
Thank you for your help in the past. I'm here with another question. I need code to get the grand total of the row totals in a pivot table. Using this grand total, I would need to delete the sheet (each sheet has only one pivot table) if the grand total is zero. I don't know what the name of the pivot table is, but I know for sure each sheet that the macro is run on will have only one pivot table. Each pivot table does have a row and column titled "Grand Total" and the grand total that I need is the summation of the totals of each individual row. The pivot table does have this data displayed on most bottom right. Any help would be greatly appreciated. -Karim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table grand total | Excel Discussion (Misc queries) | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Grand Total | Excel Discussion (Misc queries) | |||
Grand total in Pivot-Table | Excel Worksheet Functions | |||
% of Running Total to Grand Total in Pivot Table | Excel Programming |