Total Row with Difference between 2 Totals

[microwin88x]

Hello,

I have a Pivot Table like this:

ACCOUNT	DESCRIPTION	AMOUNT
INCOME	Total	$ 1.500
	DESC1	$ 300
	DESC2	$ 400
	DESC3	$ 800
EXPENSES	Total	$ 600
	DESC1	$ 100
	DESC2	$ 200
	DESC3	$ 300

What I need is to add a Total row with the result of INCOME - EXPENSES:

ACCOUNT	DESCRIPTION	AMOUNT
Total		$ 900
INCOME	Total	$ 1.500
	DESC1	$ 300
	DESC2	$ 400
	DESC3	$ 800
EXPENSES	Total	$ 600
	DESC1	$ 100
	DESC2	$ 200
	DESC3	$ 300

Is there any way to do that?

Thank you!!!

[MK9885]

What is your expression?

You want to add Total 900 with 1500 and 600?

[lorenzoconforti · Accepted solution]

In your expression for AMOUNT, write something along these lines:

=if(Dimensionality()=0,Sum({<ACCOUNT={"INCOME"}>}AMOUNT) - Sum({<ACCOUNT={"EXPENSES"}>}AMOUNT), Sum(AMOUNT))