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.
