Sorting in a multidimensional view using Rank

Version 1

    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.

     

    regular sort.png

     

    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)

     

    rank sort.png