I would like to create a calculated member that allows me to display selected month/previous month.

However, in addition I want to be able to allow for selection of multiple months and have the denominator lag the equivalent number of months backward.  i.e if the user selects months 3 and 4 the equation would be : {[datetime].[month].&[3],[datetime].[month].&[4]}/{[datetime].[month].&[1],[datetime].[month].&[2]}

Any thoughts on how to put this together?

thanks

I have been trying a bunch of different variations with ssrs parameters and string conversion... but what I am thinking now is I am going to have to use custom code in ssrs.

I am really green on VB but what I am thinking is strtoarray of the selected months, take that into a loop and inject lag into each member string... I haven't worked out all of the details yet, but I am thinking grab a count of total selected months and use that to count backwards for the lag months, starting with the min month selected.

Any thoughts?