Question
How to switch sorting by specified columns in a viz with dimensions in Rows and Columns.
Last Modified Date: 10 Aug 2023
Environment
- Tableau Desktop
Answer
The following is an example of sorting by Sales in descending order according to the Region selected by the parameter.1. Create a parameter as follows;
2. Right-click Sort by parameter and select Show Parameter.
3. Create a calculated field and name it Sort by Field.
{ EXCLUDE [Region]:SUM(IF [Region] = [Sort by] THEN [Sales] END) }
4. Add Region and SUM(Sales) to Columns.5. Add YEAR(Order Date) and SUM(Sort by Field) to Rows.
6. Right-click SUM(Sort by Field) in Rows and select Discrete.
7. Right-click SUM(Sort by Field) in Rows and uncheck Show Header.
8. Right-click YEAR(Order Date) and select Sort. Configure it as follows;
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials