1 Reply Latest reply: Dec 6, 2016 10:45 AM by Sunny Talwar RSS

    Pareto KPIs

    Lefteris Zampoulakis

      Hi

       

      I am trying to calculate in a single KPI with the number or products that contribute 80% of the sales.

       

      I currently have the following formula which however does not work.

       

      Count(if(Aggr(Rangesum(Above(Sum(Sales)/Sum(Total Sales),0,Rowno())),Product)<=0.8,Product))

       

      ProductSales
      Product 110
      Product 29
      Product 38
      Product 47
      Product 56
      Product 65
      Product 74
      Product 83
      Product 92
      Product 101