If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ranking
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 |
#2
|
|||
|
|||
ranking
Use a PivotTable, and then a Top x filter?
-- Best Regards, Luke M "liem" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|