I have the following MDX calculation in my SSAS cube that returns Prior YTD Sales based on the current date.
This will return the YTD sales for prior year, however I need a calculation to return the total sales for the entire prior year.
(based on today's date)
Example: Current YTD sales : $5,000,000
Prior YTD sales : $5,100,000
Prior Year Sales: $8,000,000 (this is the calc I can't figure out)
Any help would be greatly appreciated...