top ten ranking

L

liem

I have 20 category in each category I have random 1 to 500 items with sales
units and Sales $ metric for each items.

How can filter and rank it will show up top 10 items of combination for
Sales Units and Sales $
Cat 10 Item Sale units Sales $ Rank
bread 10 12
Cake 12 20
Cookies 8 10
"" "" ""
"" "" ""
Cat 12 Coke 120 135
Pepsi 129 132
Dr Pepper 190 198
orange 98 178
"" "" ""
Cat 13 Book1 120 201
Book 2 150 230
Book 3 145 245
Book 4 256 278
Thanks
Liem
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top