I need to create the total sales for the current year and
the last year. Since I have 2 dimensional, [Time] and
[Store], and one measure, [Sales].

It is easy to get the total sales for the current year

select
{[Measures].[Sales]} on column,
{[Year].children} on rows
from Sales

However, how can I create the calculated Members for the
last year. I try to create it as follow:

Member [Measures].[Last Year Sales] AS
'sum( StrToSet(MemberToStr([Year].currentmember) -
1) , [measures].[Sales])'

But it doesn't work

Any one can help me?

Here you go:

( [Year].CurrentMember, Measures.Sales ) +
( [Year].PrevMember, Measures.Sales )

public @ the domain below
www.tomchester.net

"Tomas Leung" <anonymous (AT) discussions (DOT) microsoft.com> wrote