Pivot table in Excel 2007

R

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.
 

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

Grand Substraction instead of Grand Total in pivot table 3
Export Pivot table 1
Pivot table calculated field Count(field) / sum(field) 0
Pivot table 1
Pivot Tables in Excel 2007 vs 2003 1
How to base a pivot table on another pivot table? 3
Looking to change pivot table orientation 4
Pivot Table Grand Total Issue 3

Top