randy.jaye (9/16/2010)

---

I have the following MDX calculation in my SSAS cube that returns Prior YTD Sales based on the current date.

Sum(YTD(ParallelPeriod([Calendar].[Year-Quarter-Month-Week-Day].[Year],1,[Calendar].[Year-Quarter-Month-Week-Day].CurrentMember)),[Measures].[Net Sales])

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...