How to determine a group ID associated with a certain criteria in Pivot Table
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.
