Top N calculation

[Sean_BI]

Dear experts..

I am looking to have a report create like below..

slab	No. of Custid	Orders	Price
Top 10% Customers	10000	10000	2000
Next 10% Customers	9000	12000	100
Next 20% Customers	16200	150000	30000
Next 30% Customers	19440	13000	200
Rest 30%	45360	13000	100

What is need is out of 1,00,000 customer, they are to be divided into various slabs like above.

Is this possible.?

Thank you!

Sean.

[Arthur_Fong · Accepted solution]

Do you have a sample app?

slab	No. of Custid	Orders	Price
Top 10% Customers	10000	10000	2000
Next 10% Customers	9000	12000	100
Next 20% Customers	16200	150000	30000
Next 30% Customers	19440	13000	200
Rest 30%	45360	13000	100

Why the third customer with 150k orders and buying the most expensive items is considered as next 20% of customers?

[Brett_Bleess · Accepted solution]

Sean, the best I have are the following link that may be of some use for some ideas in addition to what Arthur posted.

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497

Not sure if this will work or not, but figured I would toss it over for you to check out.

Regards,
Brett