http://stackoverflow.com/questions/5312493/in-ssas-cannot-make-the-parallelperiod-function-work-when-crossing-months-and-y

As mentioned in this link and in the following query, its working in the desired way. How to put this in Cube as calculated member?

SELECT

[Date].[Month of Year].CHILDREN ON ROWS,

( [Date].[Calendar Year].CHILDREN, { [Measures].[Sales Amount] } ) ON COLUMNS

FROM [Adventure Works]

Any help please?

Thanks.