Hi,

I'm triying to make a calculated member something like this...

sum({([Date].[1900]:[Date].[2003]), ([Dimension].[level].&[A])},
[Measures].[Measure2])

But it returns a blank result to me.

Can anybody help me?

I need to sum a range of data filtered by a value of other dimension.

So I need to sum from 1900 to 2003 and filter for the member a of the
client dimension in a calculated member.

Thank's in advance!!!

Un saludo,

Enrique Barceló

Hmm, the syntax seems odd, surprised you're not getting an error. Maybe
this...?

sum({[Date].[1900]:[Date].[2003]},
([Dimension].[level].&[A] , [Measures].[Measure2]) )


public @ the domain below
www.tomchester.net

"Enrique" <sanbarsl (AT) hotmail (DOT) com> wrote