topic Re: Pivot total with calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Pivot-total-with-calculated-dimension/m-p/625047#M229942 <HTML><HEAD></HEAD><BODY><P>The usual "Show Subtotals" setting (Presentation tab) should still work, despite the calculated dimension. Are there any hidden issues?</P></BODY></HTML> Mon, 24 Feb 2014 21:56:21 GMT Oleg_Troyansky 2014-02-24T21:56:21Z Pivot total with calculated dimension https://community.qlik.com/t5/QlikView/Pivot-total-with-calculated-dimension/m-p/625046#M229941 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a pivot table with 2 dimensions: "Year", and a calculated dimension. I need to add a total row at the bottom of the table (sum of all the rows in the table). Any idea?</P><P></P><P>Thanks</P></BODY></HTML> Mon, 24 Feb 2014 21:50:19 GMT https://community.qlik.com/t5/QlikView/Pivot-total-with-calculated-dimension/m-p/625046#M229941 2014-02-24T21:50:19Z Re: Pivot total with calculated dimension https://community.qlik.com/t5/QlikView/Pivot-total-with-calculated-dimension/m-p/625047#M229942 <HTML><HEAD></HEAD><BODY><P>The usual "Show Subtotals" setting (Presentation tab) should still work, despite the calculated dimension. Are there any hidden issues?</P></BODY></HTML> Mon, 24 Feb 2014 21:56:21 GMT https://community.qlik.com/t5/QlikView/Pivot-total-with-calculated-dimension/m-p/625047#M229942 Oleg_Troyansky 2014-02-24T21:56:21Z Re: Pivot total with calculated dimension https://community.qlik.com/t5/QlikView/Pivot-total-with-calculated-dimension/m-p/625048#M229943 <HTML><HEAD></HEAD><BODY><P>Hi Oleg, the <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">"Show Subtotals" is on, but the totals are incorrect....</SPAN></P></BODY></HTML> Mon, 24 Feb 2014 21:58:57 GMT https://community.qlik.com/t5/QlikView/Pivot-total-with-calculated-dimension/m-p/625048#M229943 2014-02-24T21:58:57Z Re: Pivot total with calculated dimension https://community.qlik.com/t5/QlikView/Pivot-total-with-calculated-dimension/m-p/625049#M229944 <HTML><HEAD></HEAD><BODY><P>This maybe be caused by the nature of your expression. The "totals" in the pivot table are always evaluating the same expression at the higher level of aggregation, and that's not always "correct" or the result that you expected to see.</P><P></P><P>The "common" solution is to use AGGR and to force the calculation at a certain level of detail, before aggregating up. This is impossible to do with a calculated dimension. I see two options:</P><P></P><P>1. If the calculated dimension can be uniquely identified with a single field, than that single field could be used in the AGGR, instead of the calculated dimension.</P><P></P><P>2. Otherwise, look for a way to avoid the calculated dimension and replace it with a static dimension, calculated in the script. Calculated dimensions are bad for performance anyway.</P><P></P><P>If none of those options are feasible, then it may not be possible to add a total line at the bottom.</P><P></P><P>cheers,</P><P></P><P>Oleg Troyansky</P><P>Check out my lecture on Set Analysis and Advanced Aggregation at the Masers Summit in Chicago!</P><P>www.masterssummit.com</P></BODY></HTML> Mon, 24 Feb 2014 22:07:22 GMT https://community.qlik.com/t5/QlikView/Pivot-total-with-calculated-dimension/m-p/625049#M229944 Oleg_Troyansky 2014-02-24T22:07:22Z Re: Pivot total with calculated dimension https://community.qlik.com/t5/QlikView/Pivot-total-with-calculated-dimension/m-p/625050#M229945 <HTML><HEAD></HEAD><BODY><P>You solved the problem. thanks</P></BODY></HTML> Mon, 24 Feb 2014 22:10:54 GMT https://community.qlik.com/t5/QlikView/Pivot-total-with-calculated-dimension/m-p/625050#M229945 2014-02-24T22:10:54Z