https://community.qlik.com/t5/App-Development/Total-Pivot-Table-vs-Total-Straight-Table/m-p/1699733#M53588 <P>Dear Gurús,&nbsp;</P><P>I'm doing a complex Aggr calculation in QlikSense and my problem is that the Total Result is working OK in a Straight Table but the Totals if I use a Pivot Table is wrong. I know there are some posts related to this topic but none of them are using similar formulas... This is the formula I'm using:&nbsp;</P><P>sum(AGGR((RangeMax (0, sum({&lt;[Delivery Indicator]-={'X'}&gt;}[Purchase Quantity]) - sum({&lt;[Delivery Indicator]-={'X'}&gt;}[Received Quantity]))) ,[Order - Position]))</P><P>Any idea of how can I apply this formula into a Pivot Table and see the correct Totals when I analyze this by any dimension?</P><P>Thanks!!!</P> Mon, 20 Dec 2021 21:08:46 GMT jorditorras 2021-12-20T21:08:46Z https://community.qlik.com/t5/App-Development/Total-Pivot-Table-vs-Total-Straight-Table/m-p/1699733#M53588 <P>Dear Gurús,&nbsp;</P><P>I'm doing a complex Aggr calculation in QlikSense and my problem is that the Total Result is working OK in a Straight Table but the Totals if I use a Pivot Table is wrong. I know there are some posts related to this topic but none of them are using similar formulas... This is the formula I'm using:&nbsp;</P><P>sum(AGGR((RangeMax (0, sum({&lt;[Delivery Indicator]-={'X'}&gt;}[Purchase Quantity]) - sum({&lt;[Delivery Indicator]-={'X'}&gt;}[Received Quantity]))) ,[Order - Position]))</P><P>Any idea of how can I apply this formula into a Pivot Table and see the correct Totals when I analyze this by any dimension?</P><P>Thanks!!!</P> Mon, 20 Dec 2021 21:08:46 GMT https://community.qlik.com/t5/App-Development/Total-Pivot-Table-vs-Total-Straight-Table/m-p/1699733#M53588 jorditorras 2021-12-20T21:08:46Z