topic Is Total mode for expressions possible in Pivot tables? in QlikView https://community.qlik.com/t5/QlikView/Is-Total-mode-for-expressions-possible-in-Pivot-tables/m-p/144664#M590422 <HTML><HEAD></HEAD><BODY><P>I asume yopu mean that the total expression should be different than the "line" expression. If this is correct, make your expression conditional, using, for example, dimensionality(). It may look like this:<BR />if(dimensionality()=0, avg(...), sum(...))<BR />(If I remember correctly, dimensionality()=0 for the tola row. Can't test now.)</P></BODY></HTML> Thu, 21 May 2009 23:00:49 GMT Anonymous 2009-05-21T23:00:49Z Is Total mode for expressions possible in Pivot tables? https://community.qlik.com/t5/QlikView/Is-Total-mode-for-expressions-possible-in-Pivot-tables/m-p/144663#M590421 <HTML><HEAD></HEAD><BODY><P>From time to time I use AVG of rows in total mode for straight table, but that option isn't available in Pivot table.. Can it somehow become possible?</P><P><INPUT id="gwProxy" type="hidden" /><!--Session data--><INPUT id="jsProxy" onclick="jsCall();" type="hidden" /></P><DIV id="refHTML"></DIV></BODY></HTML> Thu, 21 May 2009 18:06:08 GMT https://community.qlik.com/t5/QlikView/Is-Total-mode-for-expressions-possible-in-Pivot-tables/m-p/144663#M590421 2009-05-21T18:06:08Z Is Total mode for expressions possible in Pivot tables? https://community.qlik.com/t5/QlikView/Is-Total-mode-for-expressions-possible-in-Pivot-tables/m-p/144664#M590422 <HTML><HEAD></HEAD><BODY><P>I asume yopu mean that the total expression should be different than the "line" expression. If this is correct, make your expression conditional, using, for example, dimensionality(). It may look like this:<BR />if(dimensionality()=0, avg(...), sum(...))<BR />(If I remember correctly, dimensionality()=0 for the tola row. Can't test now.)</P></BODY></HTML> Thu, 21 May 2009 23:00:49 GMT https://community.qlik.com/t5/QlikView/Is-Total-mode-for-expressions-possible-in-Pivot-tables/m-p/144664#M590422 Anonymous 2009-05-21T23:00:49Z Is Total mode for expressions possible in Pivot tables? https://community.qlik.com/t5/QlikView/Is-Total-mode-for-expressions-possible-in-Pivot-tables/m-p/144665#M590423 <HTML><HEAD></HEAD><BODY><P>I had this same problem, dimensionality() works perfect, BUT:</P><P>- How about the total line label?? it's now 'total' but i like to have 'Average'</P><P>- Is it also possible to have 2 total lines? (one with the avg() and one with the count()??)</P><P></P></BODY></HTML> Sun, 14 Feb 2010 13:06:10 GMT https://community.qlik.com/t5/QlikView/Is-Total-mode-for-expressions-possible-in-Pivot-tables/m-p/144665#M590423 2010-02-14T13:06:10Z