hi, Can anybody tell me the mdx query to calculate the previous running 12 months and same period previous year (upto date level). For same period previous year, I tried paralleperiod(([Time Dim].[Hierarchy Time].[Year],1,[Time Dim].[Hierarchy Time].currentmember), [Measures].[Sum of Sales]) It's not working properly. It gives me correct value for the year level and the date level but not for quarter or month level. My Hierarchy Time = Year, Quarter, Month, Date. and for Previous running 12 months i don't know how to proceed. I want both as a calculated measure If any body can guide me, I would be gratefull. Thank you