Calculating difference on Pivot Table Totals

P

PSM

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arriving at totals 2
Pivot Tables (% to total within groups) 0
Countifs or a pivot 1
Count Numbers 12
Display of totals in Pivot Table Columns 0
Column Heading on each row in pivot table 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot Table - 2

Top