topic Re: Total in Pivot Table with different Weights in QlikView https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table-with-different-Weights/m-p/1229024#M856552 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P><STRONG>Sum(Aggr(quantity*price*Weight, type, month))</STRONG></P></BODY></HTML> Tue, 07 Feb 2017 17:08:34 GMT sunny_talwar 2017-02-07T17:08:34Z Total in Pivot Table with different Weights https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table-with-different-Weights/m-p/1229023#M856551 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am trying to do a pivot table however the total is not correct.</P><P></P><P><IMG alt="data.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/152319_data.PNG" style="height: 74px; width: 620px;" /></P><P></P><P>as you can see the sum o ftotal weigh should be 2.4+ 4.5= 6.9 and it is not doing the sum the right way.</P><P></P><P>¿how can it be done?</P><P></P><P>i atached the qwd and the data.</P><P></P><P>thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table-with-different-Weights/m-p/1229023#M856551 Anonymous 2020-11-25T16:16:04Z Re: Total in Pivot Table with different Weights https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table-with-different-Weights/m-p/1229024#M856552 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P><STRONG>Sum(Aggr(quantity*price*Weight, type, month))</STRONG></P></BODY></HTML> Tue, 07 Feb 2017 17:08:34 GMT https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table-with-different-Weights/m-p/1229024#M856552 sunny_talwar 2017-02-07T17:08:34Z Re: Total in Pivot Table with different Weights https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table-with-different-Weights/m-p/1229025#M856553 <HTML><HEAD></HEAD><BODY><P>sorry wrong qwd</P></BODY></HTML> Tue, 07 Feb 2017 17:36:56 GMT https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table-with-different-Weights/m-p/1229025#M856553 Anonymous 2017-02-07T17:36:56Z Re: Total in Pivot Table with different Weights https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table-with-different-Weights/m-p/1229026#M856554 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Sum(Aggr(sum(quantity)*avg(price)*Weight, month, type))</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/152331_Capture.PNG" style="height: 112px; width: 620px;" /></P></BODY></HTML> Tue, 07 Feb 2017 18:06:40 GMT https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table-with-different-Weights/m-p/1229026#M856554 sunny_talwar 2017-02-07T18:06:40Z Re: Total in Pivot Table with different Weights https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table-with-different-Weights/m-p/1229027#M856555 <HTML><HEAD></HEAD><BODY><P>thank you very much.</P></BODY></HTML> Tue, 07 Feb 2017 22:28:34 GMT https://community.qlik.com/t5/QlikView/Total-in-Pivot-Table-with-different-Weights/m-p/1229027#M856555 Anonymous 2017-02-07T22:28:34Z