Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
I have created a custom table in which we have ID, Year, Month & so on .... in the dimension list.
In the Metrics List we have all the measures wherein we have a measure which is of rolling 12 months.
But , when we plot the Year and Month Against the rolling month measure , the value gets reduced .
on the other hand if we deselect the month and year from the dimension list and plot it against any other
dimension the correct value reflects.
In my rolling 12 month expression i have used :
SUM({<Year=,Month=,YearMonth={'>$(=Max(YearMonth)-100) <=$(=Max(YearMonth))'}>}Sales)
wherein the values in IntYearMonth are 201601,201602,201603 and so on.
Any help would be appreciated.
But , when we plot the Year and Month Against the rolling month measure , the value gets reduced .
on the other hand if we deselect the month and year from the dimension list and plot it against any other
dimension the correct value reflects.
Not sure I understand this whole paragraph? when you plot Year and Month Against rolling month measure, the value gets reduced? Do you have images or a sample to share to clarify what you mean?
Hi,
Check this links
Set Analysis for Rolling Periods
Set Analysis for certain Point in Time
Hope it helps you.
Regards,
Jagan.