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 |
