Question
When a workbook is opened, is it possible to sort the data dynamically by the current month's values?
Last Modified Date: 08 Dec 2022
Environment
- Tableau Desktop
Answer
Below is an example using the Sample - Superstore. If you open the workbook on 2022/12/01, it will be sorted in descending order of Sales on 2022/12.1. Add Year(Order Date) to Columns.
2. Add Month(Order Date) to Columns.
3. Add Sub-Category to Rows.
4. Add SUM(Sales) to Text.
5. Create a calculated field and name it Sort.
IF DATETRUNC('month', [Order Date]) = DATETRUNC('month', TODAY())
THEN [Sales]
END
6. Right-click Sub-Category in Rows and select Sort.7. Edit Sort 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