topic Average in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Average-in-Pivot-Table/m-p/1261606#M397888 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I have following pivot table in my QV document</P><P></P><TABLE><TBODY><TR><TD></TD><TD>Range</TD><TD>&lt; 10,000</TD><TD></TD><TD>10,001-25,000</TD><TD></TD><TD>Total</TD><TD></TD></TR><TR><TD>TYPE</TD><TD>MONTH</TD><TD>Nos</TD><TD>AMOUNT</TD><TD>Nos</TD><TD>AMOUNT</TD><TD>Nos</TD><TD>AMOUNT</TD></TR><TR><TD>A</TD><TD>Nov-2016</TD><TD>795</TD><TD>5,974,131</TD><TD>1,144</TD><TD>18,808,103</TD><TD>1,939</TD><TD>24,782,233</TD></TR><TR><TD>A</TD><TD>Dec-2016</TD><TD>772</TD><TD>5,853,671</TD><TD>1,201</TD><TD>20,144,018</TD><TD>1,973</TD><TD>25,997,689</TD></TR><TR><TD>A</TD><TD>Jan-2017</TD><TD>863</TD><TD>6,520,365</TD><TD>1,434</TD><TD>23,976,680</TD><TD>2,297</TD><TD>30,497,045</TD></TR><TR><TD>A</TD><TD>Total</TD><TD>2,430</TD><TD>18,348,167</TD><TD>3,759</TD><TD>62,928,800</TD><TD>6,189</TD><TD>81,276,967</TD></TR><TR><TD></TD><TD><SPAN style="color: #ff0000;">Average</SPAN></TD><TD><SPAN style="color: #ff0000;">810</SPAN></TD><TD><SPAN style="color: #ff0000;">6,116,056</SPAN></TD><TD><SPAN style="color: #ff0000;">1,253</SPAN></TD><TD><SPAN style="color: #ff0000;">20,976,267</SPAN></TD><TD><SPAN style="color: #ff0000;">2,063</SPAN></TD><TD><SPAN style="color: #ff0000;">27,092,322</SPAN></TD></TR><TR><TD>B</TD><TD>Nov-2016</TD><TD>178</TD><TD>1,311,761</TD><TD>344</TD><TD>5,513,150</TD><TD>522</TD><TD>6,824,910</TD></TR><TR><TD>B</TD><TD>Dec-2016</TD><TD>179</TD><TD>1,283,190</TD><TD>281</TD><TD>4,603,125</TD><TD>460</TD><TD>5,886,315</TD></TR><TR><TD>B</TD><TD>Jan-2017</TD><TD>198</TD><TD>1,413,659</TD><TD>378</TD><TD>5,992,583</TD><TD>576</TD><TD>7,406,242</TD></TR><TR><TD>B</TD><TD>Total</TD><TD>554</TD><TD>4,008,610</TD><TD>996</TD><TD>16,108,857</TD><TD>1,550</TD><TD>20,117,467</TD></TR><TR><TD></TD><TD><SPAN style="color: #ff0000;">Average</SPAN></TD><TD><SPAN style="color: #ff0000;">185</SPAN></TD><TD><SPAN style="color: #ff0000;">1,336,203</SPAN></TD><TD><SPAN style="color: #ff0000;">332</SPAN></TD><TD><SPAN style="color: #ff0000;">5,369,619</SPAN></TD><TD><SPAN style="color: #ff0000;">517</SPAN></TD><TD><SPAN style="color: #ff0000;">6,705,822</SPAN></TD></TR><TR><TD>C</TD><TD>Nov-2016</TD><TD>135</TD><TD>936,589</TD><TD>244</TD><TD>3,902,577</TD><TD>379</TD><TD>4,839,166</TD></TR><TR><TD>C</TD><TD>Dec-2016</TD><TD>129</TD><TD>845,520</TD><TD>211</TD><TD>3,370,800</TD><TD>340</TD><TD>4,216,320</TD></TR><TR><TD>C</TD><TD>Jan-2017</TD><TD>159</TD><TD>1,117,477</TD><TD>268</TD><TD>4,166,362</TD><TD>427</TD><TD>5,283,839</TD></TR><TR><TD> </TD><TD>Total</TD><TD>421</TD><TD>2,899,585</TD><TD>711</TD><TD>11,439,739</TD><TD>1,132</TD><TD>14,339,324</TD></TR><TR><TD></TD><TD><SPAN style="color: #ff0000;">Average</SPAN></TD><TD><SPAN style="color: #ff0000;">140</SPAN></TD><TD><SPAN style="color: #ff0000;">966,528</SPAN></TD><TD><SPAN style="color: #ff0000;">237</SPAN></TD><TD><SPAN style="color: #ff0000;">3,813,246</SPAN></TD><TD><SPAN style="color: #ff0000;">377</SPAN></TD><TD><SPAN style="color: #ff0000;">4,779,775</SPAN></TD></TR><TR><TD><SPAN style="color: #ff0000;">A</SPAN></TD><TD><SPAN style="color: #ff0000;">Total</SPAN></TD><TD><SPAN style="color: #ff0000;">1,108</SPAN></TD><TD><SPAN style="color: #ff0000;">8,222,480</SPAN></TD><TD><SPAN style="color: #ff0000;">1,732</SPAN></TD><TD><SPAN style="color: #ff0000;">28,223,829</SPAN></TD><TD><SPAN style="color: #ff0000;">2,840</SPAN></TD><TD><SPAN style="color: #ff0000;">36,446,309</SPAN></TD></TR><TR><TD><SPAN style="color: #ff0000;">B</SPAN></TD><TD><SPAN style="color: #ff0000;">Total</SPAN></TD><TD><SPAN style="color: #ff0000;">1,080</SPAN></TD><TD><SPAN style="color: #ff0000;">7,982,380</SPAN></TD><TD><SPAN style="color: #ff0000;">1,693</SPAN></TD><TD><SPAN style="color: #ff0000;">28,117,943</SPAN></TD><TD><SPAN style="color: #ff0000;">2,773</SPAN></TD><TD><SPAN style="color: #ff0000;">36,100,324</SPAN></TD></TR><TR><TD><SPAN style="color: #ff0000;">C</SPAN></TD><TD><SPAN style="color: #ff0000;">Total</SPAN></TD><TD><SPAN style="color: #ff0000;">1,220</SPAN></TD><TD><SPAN style="color: #ff0000;">9,051,501</SPAN></TD><TD><SPAN style="color: #ff0000;">2,080</SPAN></TD><TD><SPAN style="color: #ff0000;">34,135,625</SPAN></TD><TD><SPAN style="color: #ff0000;">3,300</SPAN></TD><TD><SPAN style="color: #ff0000;">43,187,126</SPAN></TD></TR><TR><TD></TD><TD><SPAN style="color: #ff0000;">Total</SPAN></TD><TD><SPAN style="color: #ff0000;">3,408</SPAN></TD><TD><SPAN style="color: #ff0000;">25,256,362</SPAN></TD><TD><SPAN style="color: #ff0000;">5,505</SPAN></TD><TD><SPAN style="color: #ff0000;">90,477,397</SPAN></TD><TD><SPAN style="color: #ff0000;">8,913</SPAN></TD><TD><SPAN style="color: #ff0000;">115,733,759</SPAN></TD></TR></TBODY></TABLE><P></P><P>I want to calculate the average and <SPAN style="font-size: 13.3333px;">Grand Total</SPAN> of each type . In other words I want to show figures highlighted in red in my pivot table. Can You pls advise how to do it </P></BODY></HTML> Tue, 31 Jan 2017 03:28:47 GMT upaliwije 2017-01-31T03:28:47Z Average in Pivot Table https://community.qlik.com/t5/QlikView/Average-in-Pivot-Table/m-p/1261606#M397888 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I have following pivot table in my QV document</P><P></P><TABLE><TBODY><TR><TD></TD><TD>Range</TD><TD>&lt; 10,000</TD><TD></TD><TD>10,001-25,000</TD><TD></TD><TD>Total</TD><TD></TD></TR><TR><TD>TYPE</TD><TD>MONTH</TD><TD>Nos</TD><TD>AMOUNT</TD><TD>Nos</TD><TD>AMOUNT</TD><TD>Nos</TD><TD>AMOUNT</TD></TR><TR><TD>A</TD><TD>Nov-2016</TD><TD>795</TD><TD>5,974,131</TD><TD>1,144</TD><TD>18,808,103</TD><TD>1,939</TD><TD>24,782,233</TD></TR><TR><TD>A</TD><TD>Dec-2016</TD><TD>772</TD><TD>5,853,671</TD><TD>1,201</TD><TD>20,144,018</TD><TD>1,973</TD><TD>25,997,689</TD></TR><TR><TD>A</TD><TD>Jan-2017</TD><TD>863</TD><TD>6,520,365</TD><TD>1,434</TD><TD>23,976,680</TD><TD>2,297</TD><TD>30,497,045</TD></TR><TR><TD>A</TD><TD>Total</TD><TD>2,430</TD><TD>18,348,167</TD><TD>3,759</TD><TD>62,928,800</TD><TD>6,189</TD><TD>81,276,967</TD></TR><TR><TD></TD><TD><SPAN style="color: #ff0000;">Average</SPAN></TD><TD><SPAN style="color: #ff0000;">810</SPAN></TD><TD><SPAN style="color: #ff0000;">6,116,056</SPAN></TD><TD><SPAN style="color: #ff0000;">1,253</SPAN></TD><TD><SPAN style="color: #ff0000;">20,976,267</SPAN></TD><TD><SPAN style="color: #ff0000;">2,063</SPAN></TD><TD><SPAN style="color: #ff0000;">27,092,322</SPAN></TD></TR><TR><TD>B</TD><TD>Nov-2016</TD><TD>178</TD><TD>1,311,761</TD><TD>344</TD><TD>5,513,150</TD><TD>522</TD><TD>6,824,910</TD></TR><TR><TD>B</TD><TD>Dec-2016</TD><TD>179</TD><TD>1,283,190</TD><TD>281</TD><TD>4,603,125</TD><TD>460</TD><TD>5,886,315</TD></TR><TR><TD>B</TD><TD>Jan-2017</TD><TD>198</TD><TD>1,413,659</TD><TD>378</TD><TD>5,992,583</TD><TD>576</TD><TD>7,406,242</TD></TR><TR><TD>B</TD><TD>Total</TD><TD>554</TD><TD>4,008,610</TD><TD>996</TD><TD>16,108,857</TD><TD>1,550</TD><TD>20,117,467</TD></TR><TR><TD></TD><TD><SPAN style="color: #ff0000;">Average</SPAN></TD><TD><SPAN style="color: #ff0000;">185</SPAN></TD><TD><SPAN style="color: #ff0000;">1,336,203</SPAN></TD><TD><SPAN style="color: #ff0000;">332</SPAN></TD><TD><SPAN style="color: #ff0000;">5,369,619</SPAN></TD><TD><SPAN style="color: #ff0000;">517</SPAN></TD><TD><SPAN style="color: #ff0000;">6,705,822</SPAN></TD></TR><TR><TD>C</TD><TD>Nov-2016</TD><TD>135</TD><TD>936,589</TD><TD>244</TD><TD>3,902,577</TD><TD>379</TD><TD>4,839,166</TD></TR><TR><TD>C</TD><TD>Dec-2016</TD><TD>129</TD><TD>845,520</TD><TD>211</TD><TD>3,370,800</TD><TD>340</TD><TD>4,216,320</TD></TR><TR><TD>C</TD><TD>Jan-2017</TD><TD>159</TD><TD>1,117,477</TD><TD>268</TD><TD>4,166,362</TD><TD>427</TD><TD>5,283,839</TD></TR><TR><TD> </TD><TD>Total</TD><TD>421</TD><TD>2,899,585</TD><TD>711</TD><TD>11,439,739</TD><TD>1,132</TD><TD>14,339,324</TD></TR><TR><TD></TD><TD><SPAN style="color: #ff0000;">Average</SPAN></TD><TD><SPAN style="color: #ff0000;">140</SPAN></TD><TD><SPAN style="color: #ff0000;">966,528</SPAN></TD><TD><SPAN style="color: #ff0000;">237</SPAN></TD><TD><SPAN style="color: #ff0000;">3,813,246</SPAN></TD><TD><SPAN style="color: #ff0000;">377</SPAN></TD><TD><SPAN style="color: #ff0000;">4,779,775</SPAN></TD></TR><TR><TD><SPAN style="color: #ff0000;">A</SPAN></TD><TD><SPAN style="color: #ff0000;">Total</SPAN></TD><TD><SPAN style="color: #ff0000;">1,108</SPAN></TD><TD><SPAN style="color: #ff0000;">8,222,480</SPAN></TD><TD><SPAN style="color: #ff0000;">1,732</SPAN></TD><TD><SPAN style="color: #ff0000;">28,223,829</SPAN></TD><TD><SPAN style="color: #ff0000;">2,840</SPAN></TD><TD><SPAN style="color: #ff0000;">36,446,309</SPAN></TD></TR><TR><TD><SPAN style="color: #ff0000;">B</SPAN></TD><TD><SPAN style="color: #ff0000;">Total</SPAN></TD><TD><SPAN style="color: #ff0000;">1,080</SPAN></TD><TD><SPAN style="color: #ff0000;">7,982,380</SPAN></TD><TD><SPAN style="color: #ff0000;">1,693</SPAN></TD><TD><SPAN style="color: #ff0000;">28,117,943</SPAN></TD><TD><SPAN style="color: #ff0000;">2,773</SPAN></TD><TD><SPAN style="color: #ff0000;">36,100,324</SPAN></TD></TR><TR><TD><SPAN style="color: #ff0000;">C</SPAN></TD><TD><SPAN style="color: #ff0000;">Total</SPAN></TD><TD><SPAN style="color: #ff0000;">1,220</SPAN></TD><TD><SPAN style="color: #ff0000;">9,051,501</SPAN></TD><TD><SPAN style="color: #ff0000;">2,080</SPAN></TD><TD><SPAN style="color: #ff0000;">34,135,625</SPAN></TD><TD><SPAN style="color: #ff0000;">3,300</SPAN></TD><TD><SPAN style="color: #ff0000;">43,187,126</SPAN></TD></TR><TR><TD></TD><TD><SPAN style="color: #ff0000;">Total</SPAN></TD><TD><SPAN style="color: #ff0000;">3,408</SPAN></TD><TD><SPAN style="color: #ff0000;">25,256,362</SPAN></TD><TD><SPAN style="color: #ff0000;">5,505</SPAN></TD><TD><SPAN style="color: #ff0000;">90,477,397</SPAN></TD><TD><SPAN style="color: #ff0000;">8,913</SPAN></TD><TD><SPAN style="color: #ff0000;">115,733,759</SPAN></TD></TR></TBODY></TABLE><P></P><P>I want to calculate the average and <SPAN style="font-size: 13.3333px;">Grand Total</SPAN> of each type . In other words I want to show figures highlighted in red in my pivot table. Can You pls advise how to do it </P></BODY></HTML> Tue, 31 Jan 2017 03:28:47 GMT https://community.qlik.com/t5/QlikView/Average-in-Pivot-Table/m-p/1261606#M397888 upaliwije 2017-01-31T03:28:47Z Re: Average in Pivot Table https://community.qlik.com/t5/QlikView/Average-in-Pivot-Table/m-p/1261607#M397889 <HTML><HEAD></HEAD><BODY><P>See Attached Sample</P><P></P><P><IMG alt="wrapcell.PNG" class="jive-image image-1" height="311" src="https://community.qlik.com/legacyfs/online/151345_wrapcell.PNG" style="height: 311.55px; width: 201px;" width="201" /></P><P></P><P></P><P><IMG alt="total&amp;amp;Average.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/151364_total&amp;Average.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 31 Jan 2017 08:33:46 GMT https://community.qlik.com/t5/QlikView/Average-in-Pivot-Table/m-p/1261607#M397889 vinieme12 2017-01-31T08:33:46Z Re: Average in Pivot Table https://community.qlik.com/t5/QlikView/Average-in-Pivot-Table/m-p/1261608#M397890 <HTML><HEAD></HEAD><BODY><P>Thanks for your help,</P><P>This is not exactly what I want !</P></BODY></HTML> Tue, 31 Jan 2017 09:17:57 GMT https://community.qlik.com/t5/QlikView/Average-in-Pivot-Table/m-p/1261608#M397890 upaliwije 2017-01-31T09:17:57Z Re: Average in Pivot Table https://community.qlik.com/t5/QlikView/Average-in-Pivot-Table/m-p/1261609#M397891 <HTML><HEAD></HEAD><BODY><P>Yes, i'm only showing you how you can achieve what you want...</P><P></P><P>Another way would be to add dummy dimension values and use Pick(Match( for your expressions</P></BODY></HTML> Tue, 31 Jan 2017 09:59:37 GMT https://community.qlik.com/t5/QlikView/Average-in-Pivot-Table/m-p/1261609#M397891 vinieme12 2017-01-31T09:59:37Z