Sélectionner une organisation
How to Display RUNNING_SUM After a Specific Year and Month
Date de publication: Feb 24, 2026
Tâche
How to display RUNNING_SUM after a specific year and month?
Étapes
1. Add Year(Order Date) and Month(Order Date) to Columns.
2. Add Category to Rows.
3. Create parameters as follows;
4. Create a calculated field and name it Cumulative Sales.
RUNNING_SUM(SUM(
IF DATEPART('year', [Order Date]) >= [Year] AND DATEPART('month', [Order Date]) >= [Month] THEN [Sales]
ELSE 0
END
))
5. Add Cumulative Sales to Text.Numéro d’article de la base de connaissances
001498727
Cet article a-t-il résolu votre problème ?
Dites-nous ce que nous pouvons améliorer !
