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
