topic Pivot Chart(Calculated dimension) problem. in QlikView https://community.qlik.com/t5/QlikView/Pivot-Chart-Calculated-dimension-problem/m-p/458608#M171195 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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</P><P>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</P><P>(SUM({$&lt;Item_Ledger_Entry_Type_Code={0}&gt;}Cost_Amt_Actual)</P><P>+</P><P>SUM({$&lt;Item_Ledger_Entry_Type_Code={0}&gt;}Cost_Amt_Expected))</P><P>/100000</P></BODY></HTML> Wed, 20 Mar 2013 07:14:04 GMT rohitians 2013-03-20T07:14:04Z Pivot Chart(Calculated dimension) problem. https://community.qlik.com/t5/QlikView/Pivot-Chart-Calculated-dimension-problem/m-p/458608#M171195 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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</P><P>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</P><P>(SUM({$&lt;Item_Ledger_Entry_Type_Code={0}&gt;}Cost_Amt_Actual)</P><P>+</P><P>SUM({$&lt;Item_Ledger_Entry_Type_Code={0}&gt;}Cost_Amt_Expected))</P><P>/100000</P></BODY></HTML> Wed, 20 Mar 2013 07:14:04 GMT https://community.qlik.com/t5/QlikView/Pivot-Chart-Calculated-dimension-problem/m-p/458608#M171195 rohitians 2013-03-20T07:14:04Z