Total Pivot Table vs Total Straight Table

[jorditorras]

Dear Gurús, 

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: 

sum(AGGR((RangeMax (0, sum({<[Delivery Indicator]-={'X'}>}[Purchase Quantity]) - sum({<[Delivery Indicator]-={'X'}>}[Received Quantity]))) ,[Order - Position]))

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?

Thanks!!!