topic Subtotals in pivot table in QlikView https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-table/m-p/588412#M544806 <HTML><HEAD></HEAD><BODY><P>I am using this expression</P><P>sum({&lt; GL_Ac = {'Grs'},Fl_CY={1},[Cy Code_]={'US'} &gt;} Amount*-1*$(v_R_Sel1))/1000 in a pivot table and i have checked the show partial sums for both the dimensions. Now the totals doesn't show the right value but when i do use the aggr then it does. I am confused on why am i having the difference here? i was hoping that the pivot table does show subtotals by default and wouldn't be needing to use the aggr unless required. Any thoughts on this one?</P><P></P><P>The attached spread sheet is an export of the object that i am using the expression, which shows 1082 as total but when i really add up by row it is 1090.</P></BODY></HTML> Wed, 16 Apr 2014 19:48:10 GMT 2014-04-16T19:48:10Z Subtotals in pivot table https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-table/m-p/588412#M544806 <HTML><HEAD></HEAD><BODY><P>I am using this expression</P><P>sum({&lt; GL_Ac = {'Grs'},Fl_CY={1},[Cy Code_]={'US'} &gt;} Amount*-1*$(v_R_Sel1))/1000 in a pivot table and i have checked the show partial sums for both the dimensions. Now the totals doesn't show the right value but when i do use the aggr then it does. I am confused on why am i having the difference here? i was hoping that the pivot table does show subtotals by default and wouldn't be needing to use the aggr unless required. Any thoughts on this one?</P><P></P><P>The attached spread sheet is an export of the object that i am using the expression, which shows 1082 as total but when i really add up by row it is 1090.</P></BODY></HTML> Wed, 16 Apr 2014 19:48:10 GMT https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-table/m-p/588412#M544806 2014-04-16T19:48:10Z Re: Subtotals in pivot table https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-table/m-p/588413#M544807 <HTML><HEAD></HEAD><BODY><P>Without more detail information, your issue looks like <A href="https://community.qlik.com/docs/DOC-4777">QlikView Technical Brief - AGGR</A></P></BODY></HTML> Thu, 17 Apr 2014 02:37:58 GMT https://community.qlik.com/t5/QlikView/Subtotals-in-pivot-table/m-p/588413#M544807 2014-04-17T02:37:58Z