Hello, I have a simple table that works as expected. It contains the following fields.
Year/Period
Sum(Price)
Below(Sum(Price)
Variance (between the two prior measures)
Change ( an if/then expression to show if the measure value increased from the prior month)
![Brysonds_0-1666721877387.png Brysonds_0-1666721877387.png](https://community.qlik.com/t5/image/serverpage/image-id/92136iC5CCA07A65AC8107/image-size/medium?v=v2&px=400)
The problem I have is that when I add more dimensions (like Company and Customer), Below(Sum(Measure)) no longer works.
I tried using an aggr function to make this work, but haven't been successful.
Sum(Aggr(Below(Price), Company, Customer, Year/Period)) returns values but not the correct ones
Below(Sum(Aggr(Price, Company, Customer, Year/Period))) returns nothing
![Brysonds_1-1666722304192.png Brysonds_1-1666722304192.png](https://community.qlik.com/t5/image/serverpage/image-id/92137iD635E48A0B59B6BA/image-size/medium?v=v2&px=400)
Can anyone help with the correct approach?