I am trying to build a report in the following format.
Cross tab report based on the data coming from the cube.
There is a month and year prompt
Quantity 2012 MTD 2011 MTD 2012 YTD 2011 YTD
I need to calculate MTD, YTD, Prior MTD and Prior YTD.
I have calcuated the following in cube but cannot directly use it as it has month and year prompt.
I have seen it can be done using DMR functions..
Can any one help me in getting this solved.
Thanks in advance.