Want to subtract values of two columns in pivot table

[Anonymous]

Hi All,

Want to subtract the value like c4-d4,d4-e4,e4-f4.....attaching excel for ur refrence....

this i have to do in Pivot table....

Reply ASAP

Pls

Thanks,

Shashank

[lironbaram]

hei

do you want to show the diffrence in the same table near the sums or in a diffrent table

[#3]

i dont know if its still needet (ASAP). but the question is still open...

if you want to show the difference in the same table, you can use the "collumn()" function.

Mon(1)	Tue(2)	formula	difference
3	10	=collumn(2)-collumn(1)	7
2	11	=(collumn(2)*100)/collumn(1)	550 %
1	12	etc.

formula is collumn 3, difference is 4 a.s.o

[DeshDeepSingh]

It didnt work. What could be the best way?