In a pivot table I have groups, each group has 5 same sub categories in percentages of the total of each group : cat1, cat2, cat3, cat4 and cat5, as follows : GroupA = 100%
- cat 1 = 23%
- cat 2 = 12%
- cat 3 = 27%
- cat 4 = 8%
- cat 5 = 30%
I would like to rank these groups in a new column by sub categories aka : "what is the top 10 groups by sub category 2" ?
I tried to filter by sub category but it only ranks inside of each group