Published: 14 Apr 2023 Last Modified Date: 17 Apr 2023
How can I sort fields using the Pages shelf? Before:
Tableau Desktop 2021.2 and newer
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.
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.
9. If desired, drag the axis of Sales left and right to adjust the width of the axes.
Thank you for providing your feedback on the effectiveness of the article.