Pivot table in Excel 2007

[Newbie]

Hello experts
This pivot table has been created automatically in Excel 2007 : see the
following link
http://dl-1.free.fr/52616e646f6d495...2b3d67f4e6bf6721d/Pivottable2007template.xlsx

In this pivot table, how, you experts, will you replace the row "Grand
total" by a row "Difference" with a formula like Receipts - Expenses.
Thanks for your help!

 

[Roger Govier]

Hi

One way would be to have another column in the source data, called
Expense2 with a formula
=Expenses*-1 (replacing Expenses with the relevant cell reference) and
copying down.

Replace Expenses in the PT with Expense2 and the Grand Total will be the
difference.