Tableau Tutorial - Create Dynamic Sorting using a Parameter Control and FIXED
Allow your users to select which column/KPI/or metric they sort on with a parameter control combined with an If-Then statement. This video also uses the FIXED function, but it isn't necessary
Sounds a lot more complicated than it is.