Hi,

I have a dimension "Calendar" in which I have defined a hierarchy of "year-month." I have to build a report that has this hierarchy in the column. User will filter the month of interest in the hierarchy. I need an MDX script that returns the user selected last month...like a lastChild on a filtered data. Is it possible?

thanks