topic Qlik Sense Pivot Tables - Totals in App Development https://community.qlik.com/t5/App-Development/Qlik-Sense-Pivot-Tables-Totals/m-p/1260785#M25682 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I've set up a pivot table based on ageing of transactions, which works great. But the subtotals and total rows don't show the correct amounts from the rows below. It seems that the total rows are not actually adding up the figures that are being calculated at line level, but rather trying to apply the line-level formula logic themselves.</P><P></P><P>I've attached a screen shot.</P><P></P><P>Thanks</P><P></P><P>Paul</P></BODY></HTML> Wed, 16 Nov 2016 14:51:36 GMT seniorps 2016-11-16T14:51:36Z Qlik Sense Pivot Tables - Totals https://community.qlik.com/t5/App-Development/Qlik-Sense-Pivot-Tables-Totals/m-p/1260785#M25682 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I've set up a pivot table based on ageing of transactions, which works great. But the subtotals and total rows don't show the correct amounts from the rows below. It seems that the total rows are not actually adding up the figures that are being calculated at line level, but rather trying to apply the line-level formula logic themselves.</P><P></P><P>I've attached a screen shot.</P><P></P><P>Thanks</P><P></P><P>Paul</P></BODY></HTML> Wed, 16 Nov 2016 14:51:36 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Pivot-Tables-Totals/m-p/1260785#M25682 seniorps 2016-11-16T14:51:36Z Re: Qlik Sense Pivot Tables - Totals https://community.qlik.com/t5/App-Development/Qlik-Sense-Pivot-Tables-Totals/m-p/1260786#M25683 <HTML><HEAD></HEAD><BODY><P>What is your expression used here? Does it include some kind of if statement? I think if you add Sum(Aggr()) around your expression, you should be able to resolve your issues</P><P></P><P><STRONG>Sum(Aggr(</STRONG><EM>YourCurrentExpression</EM><STRONG>, </STRONG><EM>YourChartDimensions</EM><STRONG>))</STRONG></P></BODY></HTML> Wed, 16 Nov 2016 15:13:01 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-Pivot-Tables-Totals/m-p/1260786#M25683 sunny_talwar 2016-11-16T15:13:01Z