topic How to sum up calculated value in pivot? in QlikView https://community.qlik.com/t5/QlikView/How-to-sum-up-calculated-value-in-pivot/m-p/730685#M537864 <HTML><HEAD></HEAD><BODY><P>Hi, I am trying to sum up a calculated value field , eg&nbsp; RangeMax( Sales - Cost, 0) in a pivot table.</P><P>The table has 3 dimensions, Country, Region, Sales.</P><P>When all dimensions are expanded, the correct number is derived; however, when collapsed, it doesnt give a correct sum up at highest dimension level.</P><P>Thinking of using AGGR() function, but one of the dimension is a calculated dimension, not sure how to do it. </P><P>Anyone has an idea how to resolve this?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 15 Oct 2014 11:29:36 GMT 2014-10-15T11:29:36Z How to sum up calculated value in pivot? https://community.qlik.com/t5/QlikView/How-to-sum-up-calculated-value-in-pivot/m-p/730685#M537864 <HTML><HEAD></HEAD><BODY><P>Hi, I am trying to sum up a calculated value field , eg&nbsp; RangeMax( Sales - Cost, 0) in a pivot table.</P><P>The table has 3 dimensions, Country, Region, Sales.</P><P>When all dimensions are expanded, the correct number is derived; however, when collapsed, it doesnt give a correct sum up at highest dimension level.</P><P>Thinking of using AGGR() function, but one of the dimension is a calculated dimension, not sure how to do it. </P><P>Anyone has an idea how to resolve this?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 15 Oct 2014 11:29:36 GMT https://community.qlik.com/t5/QlikView/How-to-sum-up-calculated-value-in-pivot/m-p/730685#M537864 2014-10-15T11:29:36Z Re: How to sum up calculated value in pivot? https://community.qlik.com/t5/QlikView/How-to-sum-up-calculated-value-in-pivot/m-p/730686#M537865 <HTML><HEAD></HEAD><BODY><P>Could you post your sample qvw?</P></BODY></HTML> Wed, 15 Oct 2014 11:51:00 GMT https://community.qlik.com/t5/QlikView/How-to-sum-up-calculated-value-in-pivot/m-p/730686#M537865 tresB 2014-10-15T11:51:00Z