Pivot Table Calculation

[ndello]

Hi,
I have a pivot table where I am using grand totals on rows.
In my data area there are 2 columns with data. What I want to do is have the grand total show the difference between the 2 columns.
When I click on Field settings, I tried all the options but none seems to work.
I know I can simply put in a calculation in the next column, but depending on the size after refresh, I would need to manually drag down the cells. It also messes up printing.

Assistance is requested, thank you.

Thanks
Neil

 

[GorD]

I'm afraid a grand total is a grand total, however what you are after is a calculated field, right click within your pivot table and select formulas.

Hope this helps

 

[ndello]

TY GorD,