ranking

L

liem

How can I rank the top 5 or 10 items in the category for a location.
Location PSA Category item Day 1 day 2 day 3 day 4 day 5 day 6
1501 17 Grill Hot dog 10 12 3 8
11 7
1501 17 Grill Hot Link 3 11 12 11
5 3
1501 17 grill Corn dog 11 14 12 6 4
8
1501 17 Bakery Donut 6 8 5 8
7 9
1501 17 Bakery Eclair 8 5 7 8
10 6
1501 17 Bakery Chocolate 10 7 11 9 5
8
1501 17 Bakery Cookie 12 6 8 10 8
9
1501 17 Bakery Plain Donut 8 10 5 8 6
7
1501 17 Bakery Boston Ck 6 5 8 7 6
5

each category can have over humderd items and I only want top 5 or top 10
item show up.


thanks
 

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

Top