I need to write an MDX query where i can get the totals for all existing years plus the YTD for current year.
Our company year starts from month: December and ends in November..
Right now our cube has data from year: 2010(November 2009)
So i need to get the total number of sales or units for each year and YTD for year 2013..
Product 2010 2011 2012 2013(YTD)
P1 1320 2121 2112 100
Any guidance would be really helpful..
Its the Journey which gives you Happiness not the Destination-- Dan Millman