This content has been marked as final. Show 2 replies
I am stuck with a table calculation problem. Here are my requirements for this exercise.
1. Sub-categories should be ranked based on quantities over 4 weeks
2. Top 2 sub-categories should be shown as they are.
3. Rest of the sub-categories should be grouped as Other with their quantities rolled up to the group level
I tried using rank function and was able to do implement for one week. But I am not able to replicate the same when there are more weeks involved as some of the sub-categories don't have any data for some of the weeks. I also tried using index but not able to sort based on sum of quantities over multiple weeks.
I am attaching sample workbook which refers to Superstore data. Any help in this regard is highly appreciated.