Assuming your ParallelPeriod() is working on the dimension that you
are using to dice on rows, it makes sense that you would not see
anything in the Grand Total.

ParallelPeriod() will require a time member to be selected. There is
no time member for the tuple on the Grand Total line (or, I should
say, the time member is (All)). The calculation results in null.

David




On Mon, 14 Mar 2005 11:45:10 -0300, "Cristiano Moraes da Silva"
<cristiano (AT) dbccompany (DOT) com.br> wrote:

Ok David, I know that, but i want to get this result:

Date xxx Sales Sales in last year (ParallelPeriod)
2000 200 185
2002 350 311
Grand Total 550 496

I want to display in Grand Total: SUM ( Sales in 1999 + Sales in 2001) = 496

Cristiano.


"David Beavon" <dbeavon (AT) ufpi (DOT) com> wrote

I solve with this calculatedMember:

iif (MemberToStr( [Time].CurrentMember) = "[Time].[All Time]",
SUM( StrToSet("Axis(0)"), [Measures].[Sales last year] ) ,
[Measures].[Sales last year] )

But not works when the user move [Time] dimension to Filter Axis!
Cristiano.


"Cristiano Moraes da Silva" <cristiano (AT) dbccompany (DOT) com.br> wrote