topic Re: adding a sub-total and Avg lines to a pivot table in QlikView https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773634#M274469 <HTML><HEAD></HEAD><BODY><P>Indeed you can</P><P>Check the document I attached (<A _jive_internal="true" href="https://community.qlik.com/message/693282#693282" title="http://community.qlik.com/message/693282#693282">http://community.qlik.com/message/693282#693282</A>)</P></BODY></HTML> Wed, 14 Jan 2015 08:11:37 GMT ali_hijazi 2015-01-14T08:11:37Z adding a sub-total and Avg lines to a pivot table https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773630#M274465 <HTML><HEAD></HEAD><BODY><P>Hello got a pivot table with one dimension and several expressions</P><P>what I want is to add after each dimension value a line showing the total and another for the average as follows:</P><P><IMG __jive_id="75134" alt="sample.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/75134_sample.png" style="height: 657px; width: 620px;" /></P><P>how can this be attained?</P></BODY></HTML> Mon, 12 Jan 2015 13:39:38 GMT https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773630#M274465 ali_hijazi 2015-01-12T13:39:38Z Re: adding a sub-total and Avg lines to a pivot table https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773631#M274466 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>did you saw this?</P><P></P><P><A href="https://community.qlik.com/thread/53981">How to get Total/Subtotal in Pivot Table</A></P><P></P><P>HTH</P><P></P><P>André Gomes</P></BODY></HTML> Mon, 12 Jan 2015 13:53:41 GMT https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773631#M274466 agomes1971 2015-01-12T13:53:41Z Re: adding a sub-total and Avg lines to a pivot table https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773632#M274467 <HTML><HEAD></HEAD><BODY><P>Sorry I just forgot about the dimensionality function</P><P>it solves my silly problem</P><P>I simply forgot about it</P><P></P><P>thank you</P></BODY></HTML> Mon, 12 Jan 2015 14:11:55 GMT https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773632#M274467 ali_hijazi 2015-01-12T14:11:55Z Re: adding a sub-total and Avg lines to a pivot table https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773633#M274468 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>But you can add only one kind of subtotal (avg or sum), you can not add two subtotals at the same time.</P><P></P><P>BR</P><P></P><P>Serhan</P></BODY></HTML> Mon, 12 Jan 2015 14:32:58 GMT https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773633#M274468 Anonymous 2015-01-12T14:32:58Z Re: adding a sub-total and Avg lines to a pivot table https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773634#M274469 <HTML><HEAD></HEAD><BODY><P>Indeed you can</P><P>Check the document I attached (<A _jive_internal="true" href="https://community.qlik.com/message/693282#693282" title="http://community.qlik.com/message/693282#693282">http://community.qlik.com/message/693282#693282</A>)</P></BODY></HTML> Wed, 14 Jan 2015 08:11:37 GMT https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773634#M274469 ali_hijazi 2015-01-14T08:11:37Z Re: adding a sub-total and Avg lines to a pivot table https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773635#M274470 <HTML><HEAD></HEAD><BODY><P>Nice workaround.</P><P></P><P>BR</P><P></P><P>Serhan</P></BODY></HTML> Wed, 14 Jan 2015 08:24:33 GMT https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773635#M274470 Anonymous 2015-01-14T08:24:33Z Re: adding a sub-total and Avg lines to a pivot table https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773636#M274471 <HTML><HEAD></HEAD><BODY><P>yes as I told you before using dimensionality() function</P></BODY></HTML> Wed, 14 Jan 2015 08:47:11 GMT https://community.qlik.com/t5/QlikView/adding-a-sub-total-and-Avg-lines-to-a-pivot-table/m-p/773636#M274471 ali_hijazi 2015-01-14T08:47:11Z