Prior YTD formula

[craig322]

I have a cube that has 3 levels in the time dimension. They are year, quarter and month. I am trying to find a way that I can show the prior year to date sales when my cube is displaying year (not drilling down to the month). Currently, with the formula I am using, unless I drill down to the month, I see the entire prior year's data (which would be correct based on the formula). I want to show only the prior year's data up to the highest loaded interval in the current year. Below is my current formula.

SUM(YTD(ParallelPeriod([Time].[Year], 1, [Time].CurrentMember)),[Measures].[Sales])

Thanks