MDX Year on Year Sales by Months
- by schone
Hi all,
I'm stuck on a MDX query, I'm trying to retrieve the following results:
[Time].[2009] [Time].[2010]
[Time].[Months].Members [Measures].[Sales] [Measures].[Sales]
So I would like to compare the sales which were in 2009 against 2010 by month.
In terms of a chart I would have two series one for 2009 and 2010, the y axis would be the sales value and the x axis would be the month.
Any ideas on how to approach this?
Thanks in advance