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
Solved! Go to Solution.