How to Compare Ranks within a Dimension with Set Actions
In this tip, I show you how you can use set actions to (1) pick an item from a dimension to compare everything else to and (2) use set actions to choose a second item from the same dimension to compare to that. The set actions will also retain the rank of both fields with some show/hide tricks for the calculations.
You can get the data by unzipping the workbook, which you can get on my blog here - https://www.vizwiz.com/2019/08/compar...