How to show the difference between subtotals in a pivot table

Art_W4 If the source produces expenses as positive numbers (debits) then make sure that income items are included as negatives (credits)? That would be the correct accounting style. Then change the sign for every entry in the amount column (add a column amount * -1) and base the pivot table on that one. Or just change the sign for all expense items before you combine the expense data with the income data. I don't believe you can do this within a regular pivot table. In power pivot you could create a measure that changes the sign for all transactions in the OPEX category.

In short, clean-up/manipulate the raw data first rather than trying to fix an incorrect summary.