Delta on Pivot Table

[santharubban]

Please find the attachment

This Data:

Program Milestone	Control Model	Commodity	Cost
Program 1	C1	Part A	($78.36)
Program 1	C1	Part A	0
Program 1	C1	Part B	($44.31)
Program 1	C1	Part B	0
Program 1	C1	Part B	($1.98)
Program 1	C1	Part B	($0.98)
Program 1	C1	Part B	$0.02
Program 1	C1	Part B	($13.32)
Program 1	C1	Part B	($6.16)
Program 1	C1	Part B	($9.57)
Program 1	C1	Part C	($5.55)
Program 1	C1	Part C	($5.44)
Program 2	C2	Part A	($58.30)
Program 2	C2	Part B	($0.15)
Program 2	C2	Part B	($0.15)
Program 2	C2	Part B	($5.41)
Program 2	C2	Part B	($15.02)
Program 3	C3	Part B	($12.96)
Program 3	C3	Part B	($5.16)
Program 3	C3	Part B	($8.57)
Program 3	C3	Part C	($6.55)
Program 3	C3	Part C	($4.44)

Thanks

KSS

[santharubban]

Can anyone please help 

[sunny_talwar]

Something like this?

[santharubban · Accepted solution]

Thanks Talwar.

Yes, this will also worked, but i have figured out a simple this solution. 

Expression 1:

Sum(Cost)

Expression 2 :

Sum(cost) - First(Sum(cost))  which will give a delta.