I'm used to using sets for nested sorting, but what do you do if you ware sorting using percentages?
In the example attached, I want to sort within a regions showing items in which the region has the greatest market share. I'm completely stymied at this point. Any help is greatly appreciated!
Example file is attached.
Retrieving data ...