Hi Everyone,
I thought this was easy - but I am badly stuck with rolling period filters on my crosstab using a cube.
So I have Dim1 in the rows, Dim2 in the columns and M1 measure in the intersection. My time dimension rolls up to the Year, Quarter and Month Levels.
I need to create rolling month filters (3 and 6 months) on my report based on prompt selection on Month.
I have tried using the _add_months function but it is consistently error-ing out :(
Any cues on how to get this.
Thanks,
D
Have you tried looking at the below dimensional functions to get rolling months functionality?
lastPeriods ()
periodsToDate ()
Cheers!
Yes lastPeriods () worked like magic !
Thanks :)