Pareto KPIs

[Anonymous]

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

[sunny_talwar]

May be check this out:

ABC Analysis in Qlikview