Sélectionner une organisation
Sorting Monthly Values by the Values for the Current Month and Current Year
Date de publication: Apr 13, 2026
Tâche
Sorting Monthly Values by the Values for the Current Month. Example: Sorting monthly sales value for category by current month and year sales
Étapes
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 :
Numéro d’article de la base de connaissances
001456723
Cet article a-t-il résolu votre problème ?
Dites-nous ce que nous pouvons améliorer !
