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!!!
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?
