Nested Sort Button

Published: 29 Jul 2016
Last Modified Date: 24 Sep 2020

Question

How to sort logically as with a Nested Sort using a single button.

Environment

Tableau Desktop

Answer

As this feature was added to Tableau Desktop 2018.2, upgrade to Tableau Desktop 2018.2 or a later version. For more information, see Upgrading Tableau Desktop in Tableau Help.
For older version below can be a workaround.

Step 1 :

Create a combined field of Category and Sub Category

Step 2:

Use the combined field in the view in the last second position

Step 3:

Right- Click the combined field -> Sort -> Ascending/ Descending by field Sum(Sales)

Step 4:

Right click and deselect Show header for combined field