can i add subtotals to subtotals in a pivot table?
I've added subtotals to one of my outer columns, and at the bottom instead of
a grand total, want to compare the totals of those subtotals. Because the length of the pivot table changes based on the page selections people make, i can't get it to work easily with calculations outside of the pivot table. |
can i add subtotals to subtotals in a pivot table?
Excel 2007
This lets you do math operations on Pivot Table Subtotals outside the PT. Auxiliary table is dynamic. http://www.mediafire.com/file/zb3nmywgtjz/01_23_09.xlsm |
All times are GMT +1. The time now is 08:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com