Question
Sorting Monthly Values by the Values for the Current Month. Example: Sorting monthly sales value for category by current month and year sales
Last Modified Date: 08 Jul 2022
Environment
- Tableau Desktop
Answer
1. Create a view with your date dimension and measure value(Example: Sales)2. Create a calculated field Sort calc like below:
if YEAR([Order Date]) = YEAR(today()) and MONTH([Order Date]) = MONTH(today())
then ([Sales]) end
3. Right click on dimension in rows -> Sort -> Sort by field -> choose Sort calc as the field in descending order
The final result looks like below with all sales values sorted by current month sales i.e. June :
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