I need a KPI to sum the total sales below 25% of the average sales. The average sales % calculates as follows
for example if my sales average is 100 I need to sum up all the vales below 25
I'm sure it's a aggr function but I can't get it to work
Thanks in advance
Would you be able to show what you have by sharing a sample or by showing some images?
sum(if((avg(sales)/avg(ALL Sales)) <0.25, sales, 0))
why the zero at the end?
Just the false part of the If, not really necessary if Summing I suppose.
I answered my own question as follows
sum(aggr(if (Avg(Sales)/Avg(TOTAL Sales) <0.25,Sales ),Sales))
Aggregating this by sales? Not a great idea... but if it works for you... then feel free to use it
Retrieving data ...