Tableau's sort feature doesn't work when you want to sort a view in a multidimensional view. Using the orders data source as an example. If you wanted to sort the product sub-category by profit (highest to lowest), you don't get the expected results.
The work around is to sort by a ranked calculated field as follows:
- Create a calculated field as: RANK(SUM([Profit]))
- Place the calculated field (discreet) before Sub-Category
- Change the "compute using" to Pane down
- Uncheck the "Show Header" property
Now the sorting looks correct: (workbook attached)