topic Re: Wrong Total in a Pivote Table, Why???? in QlikView https://community.qlik.com/t5/QlikView/Wrong-Total-in-a-Pivote-Table-Why/m-p/365923#M575424 <HTML><HEAD></HEAD><BODY><P> Hi Jason, Thanks foe your Reply, I found the solution, we can do it using set analisys, I attached the app.</P><P></P><P>Thank you I appreciate your time and reply.</P><P></P><P></P><P>BG.</P></BODY></HTML> Wed, 23 May 2012 15:51:48 GMT 2012-05-23T15:51:48Z Wrong Total in a Pivote Table, Why???? https://community.qlik.com/t5/QlikView/Wrong-Total-in-a-Pivote-Table-Why/m-p/365921#M575422 <HTML><HEAD></HEAD><BODY><P> Hi Guys, I just don´t understand why my totals in this pivote table is wrong, please does any body have any idea???</P><P></P><P>I attached the app, Thank you Guys!!</P></BODY></HTML> Wed, 23 May 2012 15:11:29 GMT https://community.qlik.com/t5/QlikView/Wrong-Total-in-a-Pivote-Table-Why/m-p/365921#M575422 2012-05-23T15:11:29Z Re: Wrong Total in a Pivote Table, Why???? https://community.qlik.com/t5/QlikView/Wrong-Total-in-a-Pivote-Table-Why/m-p/365922#M575423 <HTML><HEAD></HEAD><BODY><P>This is a classic issue and is to do with your use of Avg().&nbsp; The "Total" is not a sum of all the other totals but the average across all dimension values.&nbsp; With an average this will most likely be different.&nbsp; In the attached file I have copied the pivot table as a straight table for you and added the same expression, but this time selected "Sum of rows" for the total (you can't do this in a pivot table).</P><P></P><P>Hope this explains it!</P><P></P><P>Jason</P></BODY></HTML> Wed, 23 May 2012 15:18:53 GMT https://community.qlik.com/t5/QlikView/Wrong-Total-in-a-Pivote-Table-Why/m-p/365922#M575423 Jason_Michaelides 2012-05-23T15:18:53Z Re: Wrong Total in a Pivote Table, Why???? https://community.qlik.com/t5/QlikView/Wrong-Total-in-a-Pivote-Table-Why/m-p/365923#M575424 <HTML><HEAD></HEAD><BODY><P> Hi Jason, Thanks foe your Reply, I found the solution, we can do it using set analisys, I attached the app.</P><P></P><P>Thank you I appreciate your time and reply.</P><P></P><P></P><P>BG.</P></BODY></HTML> Wed, 23 May 2012 15:51:48 GMT https://community.qlik.com/t5/QlikView/Wrong-Total-in-a-Pivote-Table-Why/m-p/365923#M575424 2012-05-23T15:51:48Z Re: Wrong Total in a Pivote Table, Why???? https://community.qlik.com/t5/QlikView/Wrong-Total-in-a-Pivote-Table-Why/m-p/365924#M575425 <HTML><HEAD></HEAD><BODY><P>Please mark your own answer as correct so the thread looks answered.</P><P></P><P>Cheers,</P><P></P><P>Jason</P></BODY></HTML> Wed, 23 May 2012 16:16:30 GMT https://community.qlik.com/t5/QlikView/Wrong-Total-in-a-Pivote-Table-Why/m-p/365924#M575425 Jason_Michaelides 2012-05-23T16:16:30Z