Aggr and Set Expression

[#1]

Hi

I am stuck with the Aggr function which tends to return nothing instead of my requested value.

I am also a bit confused as of where to place the set expression and whether to use max or rangemax:

1)     =max ( Aggr( sum( { [S1] <AccountID={1200} >} Value), Year) )

2)     =rangemax ( Aggr ( sum( { [S1] <AccountID={1200} >} Value), Year) )

placing the set after Aggr shows me the red underline on the first "{" so I assume the documentation is incorrect which states that I can use a set expression after Aggr?

3)     =max ( Aggr( {[S1] <AccountID={1200} >} sum(Value), Year) )

4)     =rangemax( Aggr( {[S1] <AccountID={1200} >} sum(Value), Year )

I also tried

5)     =max({[S1] <AccountID={1200} >} Aggr(sum(Value), Year))

I tried it also with using other dimensions than Year and some of them returned results but I can't figure out where I am going wrong.

Juerg

[Jason_Michaelides]

What is [S1]?

[#3]

Hi

I need to sync the scaling in different graphs which reside in different Alternate Selection Sets. These are named S1, S2 etc. So instead of using $ I need to use [Alternate Set Name].