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)
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
Can anyone help with the correct approach?