Pivot Chart(Calculated dimension) problem.

[rohitians]

Hello,

I have a pivot chat where in i calculate purchase ammount location wise in every quater month wise....problem is i want the the net purchase amount location wise

which i am not able to put in as expression can i calculate this amount n put it as an calculated dimension r any thng else solution can be done the formula for that is

(SUM({$<Item_Ledger_Entry_Type_Code={0}>}Cost_Amt_Actual)

+

SUM({$<Item_Ledger_Entry_Type_Code={0}>}Cost_Amt_Expected))

/100000