Sometimes you really need to see the top n values in different categories, which is surprisingly tricky in Tableau! Here’s a quick guide to doing that with index().
For Compute Using select Specific Dimensions
For this example, check all field names under Specific Dimensions to avoid partitioning the data. Unchecking [Abilities] at this point will make it a partitioning field, and more importantly NOT an addressing field. So, if the box is unchecked then when the table calc gets to the ‘Sort Order’ field it would ignore [Abilities] in the calculation.
At the level doesn’t matter for this example – leave it set to Deepest.
Restarting Every needs to be set to [Abilities]. You may need to drag Abilities higher in the Specific Dimensions checklist to select it here.
For Sort Order select custom, and then [Ability Score], Sum(), and Descending. This forces index to count starting with the highest Ability Score in each category, instead of the default first record.