Rolling Period filters using a Cube in Report Studio

[damzI]

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

[charlie]

Have you tried looking at the below dimensional functions to get rolling months functionality?
lastPeriods ()
periodsToDate ()

Cheers!

[damzI]

Yes lastPeriods () worked like magic !
Thanks :)