how to subtract lines in pivot table

[#1]

hello,

is it possible to subtract lines in a pivot table?

example :

Table :

C or P	Date	Amount
C	01/01/2012	500
C	01/02/2012	600
P	01/03/2012	6000
P	01/01/2012	50
P	01/01/2012	50
C	01/01/2012	200

Pivot table :

C or P	Date
P	6100
C	1300
Difference	4800

Pivot table 2

C or P	Jan 2012	Fev 2012	Mar. 2012	Total
P	100	0	6000	6100
C	700	600	0	1300
Difference	-600	-600	6000	4800

How to calculate the line "Difference" please ?

Thanks for your help

[#2 · Accepted solution]

Hi,

Would this help?

Regards,

Kiran Rokkam.

[#3]

thanks you for your help

is it possible to put the negative amount when P is less than C ?

[#4]

I found the solution just replace 'fabs' by 'num' and replace the formula like this :

NUM(Sum({<[C/P]={'P'}>} Amount)-Sum({<[C/P]={'C'}>} Amount))