Previous 11months data using DMR

[srinu_anu2007]

Hi,

I have a requirement in crosstab i.e jan,feb,mar....dec[this is for 2014 year] if i select jan i want to display 2013 dec,2013 nov.....upto 11months dat should display and the same as quarters also. Can anybody face this issue please let me know your answers.

Thanks,

[hittony]

Just a filter should work it out :

where [MONTH] between  _add_months ( ?PARAMETER_MONTH? , -11 ) and ?PARAMETER_MONTH?

[Satheesh]

Hi,


lastPeriods ( integer_expression , member )


lastPeriods (12;[Month] -> ?Mnth_Param? )

the above [Month] is member.


Use the above function in Slicer




Regards
Sateesh