Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Product | Sales |
---|---|
Product 1 | 10 |
Product 2 | 9 |
Product 3 | 8 |
Product 4 | 7 |
Product 5 | 6 |
Product 6 | 5 |
Product 7 | 4 |
Product 8 | 3 |
Product 9 | 2 |
Product 10 | 1 |
May be check this out: