topic Re: Pivot table other totals in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-other-totals/m-p/1297182#M842099 <HTML><HEAD></HEAD><BODY><P>please provide some sample data and sketch the desired result...</P></BODY></HTML> Fri, 21 Apr 2017 10:47:20 GMT Anonymous 2017-04-21T10:47:20Z Pivot table other totals https://community.qlik.com/t5/QlikView/Pivot-table-other-totals/m-p/1297181#M842098 <HTML><HEAD></HEAD><BODY><P>I Have a pivot table and i want the subtotals to be calculated as a sum of the rows on the most aggregated level.</P><P></P><P>Example: I want to see 350 as a result of the subtotal in my pivat table and not 383</P><P>When using a straight table i can simply go to expressions and change the total mode, with pivot table i can't </P><P></P><P>What should i do ? </P><P><IMG alt="problem.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160793_problem.png" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Pivot-table-other-totals/m-p/1297181#M842098 2020-11-25T16:16:04Z Re: Pivot table other totals https://community.qlik.com/t5/QlikView/Pivot-table-other-totals/m-p/1297182#M842099 <HTML><HEAD></HEAD><BODY><P>please provide some sample data and sketch the desired result...</P></BODY></HTML> Fri, 21 Apr 2017 10:47:20 GMT https://community.qlik.com/t5/QlikView/Pivot-table-other-totals/m-p/1297182#M842099 Anonymous 2017-04-21T10:47:20Z Re: Pivot table other totals https://community.qlik.com/t5/QlikView/Pivot-table-other-totals/m-p/1297183#M842100 <HTML><HEAD></HEAD><BODY><P>try like below</P><P></P><P>Sum ( AGGR ( YourExpression , FiedinDimension) )</P></BODY></HTML> Fri, 21 Apr 2017 11:31:45 GMT https://community.qlik.com/t5/QlikView/Pivot-table-other-totals/m-p/1297183#M842100 vinieme12 2017-04-21T11:31:45Z Re: Pivot table other totals https://community.qlik.com/t5/QlikView/Pivot-table-other-totals/m-p/1297184#M842101 <HTML><HEAD></HEAD><BODY><P>use below expression</P><P></P><P><STRONG>AVG( total &lt;Contry&gt; Sales)</STRONG></P><P></P><P>Now check partial sum option in presentation tab</P></BODY></HTML> Fri, 21 Apr 2017 12:37:35 GMT https://community.qlik.com/t5/QlikView/Pivot-table-other-totals/m-p/1297184#M842101 Kushal_Chawda 2017-04-21T12:37:35Z