Count/sum Large with not to exceed

I have 321 clients, each with sales and cost of sales values. Trying to apply the 80/20 rule to determine the sum of cost of sales for the clients that comprise the top 80% of sales, starting with the client with the largest sales. Also want to get a count of how many clients make up the top 80% of sales.

By: Ricky Ward

Leave a Reply

Your email address will not be published. Required fields are marked *