Pivot table Difference instead of total

[#1]

Dear Experts

     Can anyone solve this simple problem which i am facing, In the below picture instead of getting partial sum i wanted actual - budget difference.

Thanks in Advance

[stigchel · Accepted solution]

You can us chart inter record functions and the fact that the SecondaryDimensionality()=0 for the partial sum, so e.g. for the Cost expression

=if(SecondaryDimensionality()=0,

First(Sum(Cost))-First(Sum(Cost),2),

Sum(Cost)

)

[#3]

Fantastic..!!!!

it works..!

Thank you very much Piet Hein van der Stigchel