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!!!