ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can i add subtotals to subtotals in a pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/217523-can-i-add-subtotals-subtotals-pivot-table.html)

JEM

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.

Herbert Seidenberg

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