Identify count of vendors based on spend

[#1]

I have vendor level information for different groups. I need to find out the number of vendors in each group based on the overall spend. For Ex: In Group A 100 Vendors contribute to 100% of the spend, i need to identify number of vendors contributing to 80% of the spend. Basically i need to put an input box, if a set it to 70% it shows me number of vendors contributing to 70% spend and so on. Would be helpful if somebody can help me in this.

Thanks,

Sumit

[sunny_talwar]

This might be helpful -> Qlik Design Blog : Recipe for a Pareto Analysis | Qlik Community

[swuehl]

You can use a pareto select action to select customers in an alternate state triggered by your variable change.

Something like attached, taken from an older post of me:

Background color depending of accumulated sum(sales)

There is also a more recent blog post by Oleg that describes something similar:

So How Many Customers Make Up Most of Your Sales?