Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please can you help me resolving the issue that i have in that expression :
I am trying to get the accumulated sum of my last 3 months.
For that i created a date dimension based on the year and the number of the month that i get from my dataset and a Date-2 dimension, to give me the Date-2months.
Please find attached my application any help is appreciate.
Thanks a lot
Set analysis calculates one set per chart, not a set per dimension value. If you use month as a dimension and you want a 3-month accumulated sum then using set analysis is very tricky. I find it easiest to create a new table that links each month value with the last 3 months. See this document for more information: Calculating rolling n-period totals, averages or other aggregations