I have a pivot table that classifies the usage rates of a product into different buckets. Each bucket has an ID. I need way to determine the ID of the usage rate group that has the highest revenue and do some calculations on it. I have figured out how to determine the relative rank amongst the groups using Aggr but I'm stuck on how to get to the 'Winner Group' row. Any help would be appreciated.
Example:
UsageGroup: 1-10 10-25 50-100
Group ID: 1 2 3
Revenue: $10 $25 $5
Relative Rank: 2 1 3
Winner Group: 2 2 2