topic Re: Control expression total in pivot table in QlikView https://community.qlik.com/t5/QlikView/Control-expression-total-in-pivot-table/m-p/648983#M474119 <HTML><HEAD></HEAD><BODY><P>Thank You!</P></BODY></HTML> Thu, 02 Oct 2014 16:18:25 GMT dafnis14 2014-10-02T16:18:25Z Control expression total in pivot table https://community.qlik.com/t5/QlikView/Control-expression-total-in-pivot-table/m-p/648981#M474117 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In a pivot table, I use the following expression to show difference which will be presented in % :</P><P> [Actual Demand]/[Optimal Demand]-1</P><P></P><P>But in the Total, it shows the sum of all the differences.</P><P>Is it possible to control this behavior to show the average in the total?</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 02 Oct 2014 10:53:13 GMT https://community.qlik.com/t5/QlikView/Control-expression-total-in-pivot-table/m-p/648981#M474117 dafnis14 2014-10-02T10:53:13Z Re: Control expression total in pivot table https://community.qlik.com/t5/QlikView/Control-expression-total-in-pivot-table/m-p/648982#M474118 <HTML><HEAD></HEAD><BODY><P>Hard to say without a sample.. I would guess something like this will help you:</P><P>If(Dimensionality()&gt;0, [Actual Demand]/[Optimal Demand]-1,</P><P> Avg(Aggr([Actual Demand]/[Optimal Demand]-1, Dimension1, Dimension2...))</P><P>)</P></BODY></HTML> Thu, 02 Oct 2014 11:30:58 GMT https://community.qlik.com/t5/QlikView/Control-expression-total-in-pivot-table/m-p/648982#M474118 rubenmarin 2014-10-02T11:30:58Z Re: Control expression total in pivot table https://community.qlik.com/t5/QlikView/Control-expression-total-in-pivot-table/m-p/648983#M474119 <HTML><HEAD></HEAD><BODY><P>Thank You!</P></BODY></HTML> Thu, 02 Oct 2014 16:18:25 GMT https://community.qlik.com/t5/QlikView/Control-expression-total-in-pivot-table/m-p/648983#M474119 dafnis14 2014-10-02T16:18:25Z