topic Issues with Totals in PIVOT TABLE in QlikView https://community.qlik.com/t5/QlikView/Issues-with-Totals-in-PIVOT-TABLE/m-p/955353#M957256 <HTML><HEAD></HEAD><BODY><TABLE><TBODY><TR><TD>Type</TD><TD>Sales</TD></TR><TR><TD>Total</TD><TD>40951.08</TD></TR><TR><TD>DISTRO</TD><TD>18047.27</TD></TR><TR><TD>DPUD</TD><TD>-68.16</TD></TR><TR><TD>REGULAR</TD><TD>40868.04</TD></TR></TBODY></TABLE><P></P><P></P><P>Hi,</P><P></P><P>This is the Data I am working on.when i click Distro alone i am able to get the correct total of it when expanded it gives all the data but when collapsed its not adding the DISTRO data but its adding all other data.Let me know whats the issue.</P><P></P><P>Thanks in Advance</P></BODY></HTML> Fri, 06 Nov 2015 17:10:42 GMT 2015-11-06T17:10:42Z Issues with Totals in PIVOT TABLE https://community.qlik.com/t5/QlikView/Issues-with-Totals-in-PIVOT-TABLE/m-p/955353#M957256 <HTML><HEAD></HEAD><BODY><TABLE><TBODY><TR><TD>Type</TD><TD>Sales</TD></TR><TR><TD>Total</TD><TD>40951.08</TD></TR><TR><TD>DISTRO</TD><TD>18047.27</TD></TR><TR><TD>DPUD</TD><TD>-68.16</TD></TR><TR><TD>REGULAR</TD><TD>40868.04</TD></TR></TBODY></TABLE><P></P><P></P><P>Hi,</P><P></P><P>This is the Data I am working on.when i click Distro alone i am able to get the correct total of it when expanded it gives all the data but when collapsed its not adding the DISTRO data but its adding all other data.Let me know whats the issue.</P><P></P><P>Thanks in Advance</P></BODY></HTML> Fri, 06 Nov 2015 17:10:42 GMT https://community.qlik.com/t5/QlikView/Issues-with-Totals-in-PIVOT-TABLE/m-p/955353#M957256 2015-11-06T17:10:42Z Re: Issues with Totals in PIVOT TABLE https://community.qlik.com/t5/QlikView/Issues-with-Totals-in-PIVOT-TABLE/m-p/955354#M957257 <HTML><HEAD></HEAD><BODY><P>What do you get when you copy the expression in a text box?</P><P></P><P>In a pivot table, QV will calculate the total as expression total, while you might expect a sum of rows.</P><P><SPAN style="font-size: 13.3333px;">There might be a difference between the two, e.g.when a sales record can belong to more than one Type.</SPAN></P><P></P><P>You can use advanced aggregation to get the sum of rows:</P><P></P><P>=Sum( Aggr( <EM>YourExpression</EM>, Type))</P></BODY></HTML> Fri, 06 Nov 2015 17:53:32 GMT https://community.qlik.com/t5/QlikView/Issues-with-Totals-in-PIVOT-TABLE/m-p/955354#M957257 swuehl 2015-11-06T17:53:32Z