I have a CustomerName, Months, Year dimensions.
I am showing my customer and year dimensions to the left and months
dimensions at the top. I am agreggating my sales by customer/year by months.
I need to calculate the difference between the same month in different
years. How can I do that?

Thanks

The ParallelPeriod() function could be useful, like in comparing to the
previous year:

'[Measures].[Sales] -
([Measures].[Sales], ParallelPeriod([Year].[Year]))'

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***