So one way (I think actually the only way!) to do this is to use the fact that Tableau sorts Blue pills in Ascending order, and so everything to the right also gets sorted.
I created the following calculation (and made is discrete)
[Cal_filed - SORTER SR]
the *-1 is so we get a descending sort (as it sorts ascending, the negative gives a descending sort)
I bring this in to the left of Company, then as you change the parameter the sort also changes.
Hope that helps
Sort_Desc on TC 10.4.twbx 71.8 KB