Sorting Fields Using Pages Shelf

Published: 14 Apr 2023
Last Modified Date: 17 Apr 2023

Question

How can I sort fields using the Pages shelf?
Before:
User-added image

After:

Environment

Tableau Desktop 2021.2 and newer
Windows
Excel

Answer

We will sort by each page without filters in the example below.

Please follow along with the attached packaged workbook which you can find to the right of these instructions under the "Attachments" section.

1. Create a calculated field with the following configuration:

Name: Rank
Value: RANK(SUM([Sales]))

2. Drag Sales to Columns, twice (the first for text, the second for the bar graph).
3. Drag Order Date to Pages.
4. Drag State/Province to Text and Details.
5. Drag Region to color.
6. Drag Rank to Rows, and right-click to change to Discrete.
7. Right-click Rank and select Edit Table Calculation. Chose the selections listed below.
User-added image

8. Go to the first Sales, and set the color opacity to 0% by using the Edit Colors option. Lastly, as shown in the second screenshot below, Click Label then alignment > horizontal to the left.
User-added image