topic Re: Result Total - Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Result-Total-Pivot-Table/m-p/875721#M305835 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG style="text-decoration: line-through;">=Sum(Aggr(</STRONG><SPAN style="text-decoration: line-through;">YourCurrentExpression<STRONG>, </STRONG>AllDimensionsInTheTable</SPAN><STRONG style="text-decoration: line-through;">))</STRONG></P><P><STRONG><STRONG style="font-size: 13.3333330154419px;">=Avg(Aggr(</STRONG></STRONG><SPAN style="font-size: 13.3333330154419px;">YourCurrentExpression</SPAN><STRONG><STRONG style="font-size: 13.3333330154419px;">, </STRONG></STRONG><SPAN style="font-size: 13.3333330154419px;">AllDimensionsInTheTable</SPAN><STRONG><STRONG style="font-size: 13.3333330154419px;">))</STRONG></STRONG></P></BODY></HTML> Mon, 22 Jun 2015 18:19:28 GMT sunny_talwar 2015-06-22T18:19:28Z Result Total - Pivot Table https://community.qlik.com/t5/QlikView/Result-Total-Pivot-Table/m-p/875720#M305834 <HTML><HEAD></HEAD><BODY><P>Dear,</P><P></P><P>Good afternoon, would be so kind to help me with the following problem.</P><P></P><P>The totals presented not match the average of the values. Example in the designated column should appear which is the average 33.1 (Pivot Table). I would suggest that you can do or how I can fix it. Attached Excel table.</P><P><IMG alt="Problemas.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/90308_Problemas.jpg" /></P><P> In advance my sincere thanks.</P><P></P><P>Regards</P><P>Mauro</P></BODY></HTML> Mon, 22 Jun 2015 16:07:19 GMT https://community.qlik.com/t5/QlikView/Result-Total-Pivot-Table/m-p/875720#M305834 2015-06-22T16:07:19Z Re: Result Total - Pivot Table https://community.qlik.com/t5/QlikView/Result-Total-Pivot-Table/m-p/875721#M305835 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG style="text-decoration: line-through;">=Sum(Aggr(</STRONG><SPAN style="text-decoration: line-through;">YourCurrentExpression<STRONG>, </STRONG>AllDimensionsInTheTable</SPAN><STRONG style="text-decoration: line-through;">))</STRONG></P><P><STRONG><STRONG style="font-size: 13.3333330154419px;">=Avg(Aggr(</STRONG></STRONG><SPAN style="font-size: 13.3333330154419px;">YourCurrentExpression</SPAN><STRONG><STRONG style="font-size: 13.3333330154419px;">, </STRONG></STRONG><SPAN style="font-size: 13.3333330154419px;">AllDimensionsInTheTable</SPAN><STRONG><STRONG style="font-size: 13.3333330154419px;">))</STRONG></STRONG></P></BODY></HTML> Mon, 22 Jun 2015 18:19:28 GMT https://community.qlik.com/t5/QlikView/Result-Total-Pivot-Table/m-p/875721#M305835 sunny_talwar 2015-06-22T18:19:28Z