I can't open your workbook but think I know the answer. Drag your sort pill to the rows shelf, set it to discrete (blue) and place it as the left most pill, in front of the sales person pill. You can un-check Show Header to hide it. You might need to multiply by -1 to get the correct sort order.
1 of 1 people found this helpful
I believe it's because you are using ATTR in your Sort Field calculation. Per the Tableau help page, ATTR cannot be used in a sorting function on a cross tab.
This is because you can get '*' as a result with ATTR and it doesn't know how to make the sort. Your formulas are resulting in '*' values in some cases.
Try changing your formula to use another aggregation that is appropriate (MIN, AVG, etc). I used MIN in my example below, but you'll want to test to make sure you're getting the values that you want from each selection.
I was able to choose the Sort Field as an option with this change.
Alternatively, you could pre-aggregate your calcs for commission and achievement, in which case you would not need to specify aggregations for them in your Sort calculation.
Example with commission:
Either of these should work, just depends on your use case and making sure it calculates as expected.
This fixed it. Thanks, Jim!