• No replies
15496 Posts

Pinned topic Calucation of MTD, YTD using Month and Year Prompt

‏2013-01-09T16:55:26Z |
Hi all,

I am trying to build a report in the following format.
Cross tab report based on the data coming from the cube.

Report format

There is a month and year prompt

Quantity 2012 MTD 2011 MTD 2012 YTD 2011 YTD
Product info

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.