I have a cube with a Year dimension and a Month dimension (allows me to set
the year as a Page field and the month as a column field). I am trying to
calculate a Past Due amount without success. Here is my calculated member:

Sum(PeriodsToDate([Month].[(All)],[Month].PrevMember), [Measures].[Cost]) +
Sum(PeriodsToDate([Year].[(All)], [Year].PrevMember), [Measures].[Cost])

I was hoping to get sum of all months for previous years plus the sum of
months up to the previous month for the current year. What I am getting is
the sum of months up to the previous month for all years (previous and
current).

Thanks,
Nate.

Try explicitly specifying the 2nd dimension in each sum:

([Measures].[Cost], [Year].CurrentMember)) +
Sum(PeriodsToDate([Year].[(All)], [Year].PrevMember),
([Measures].[Cost], Month].[All Months]))

- Deepak

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!