Ideas how to solve this: What 50 line items drive 90% of the sales.

Occasional Visitor
Basically the data set will include the sales by each items in the previous year. Any ideas what is the best way to solve this? Pivot tables, formulas? Anything will help. Thank you!!!
1 Reply
Just sort the list based on sales from high to low and pull off the top 50 items for the top 50 or if you need 90% then add a running sum for total sum or total percent. Or am I missing something?