ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculating difference on Pivot Table Totals (https://www.excelbanter.com/excel-discussion-misc-queries/64951-calculating-difference-pivot-table-totals.html)

PSM

Calculating difference on Pivot Table Totals
 
I have a pivot Table as follows

Region State jan Feb ... Columm
North NY 1 5
NJ 5 1
North Total 6 6

South FL 2 6
GA 6 2
South Total 8 8

Grand Total 14 14

I would like to change the display of Grand total to show the difference
between the region as follows

Grand total difference (2) (2)

Any help on this is greatly appreciated.




All times are GMT +1. The time now is 07:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com