6 Replies Latest reply: Jan 29, 2018 3:08 PM by David Forest RSS

    sum of total sales based on values below an average % range

    Andy Cosgrove

      Hi All.


      I need a KPI to sum the total sales below 25% of the average sales. The average sales % calculates as follows

      avg(sales)/avg(total sales).


      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