Tableau has great built-in sorting options, but sometimes you might want to give your report user the flexibility to choose how and what to sort by.
Below you can see a simple workbook which gives the user the ability to sort product Sub-Category by a number of measures and to quickly switch between ascending and descending.
Feel free to download the workbook above to understand how to recreate this yourself, or read on for step by step instructions
Create two parameters
1. Sort by - which has the measures you want the user to be able to sort by
2. Sort direction - either ascending or descending
Create the following calculated field
Sort Sub-Category by Selected Sort
Hope this is useful! Any questions or comments please feel free to leave below, or alternatively you can contact us at firstname.lastname@example.org