Expression for Calculated Dim!!!

[buzzy996]

hi,

i have 4 level4 in Selections(Level1,Level2,Level3,Level4)

i need like this--->if i selected  Level1 from Selections need to display Level2 objects as X-Axis else

                                            Level2 from Selections need to display Level3 objects as X-Axis  else

                                            Level3 from Selections need to display Level4 objects as X-Axis. else Level1.

Could you pls let meknow any one,how to write  Expression for Calculated Dim?

thx

[Anonymous]

Hi,

Please provide some sample data of your model and description of it.

[buzzy996]

PFA,

Thanking you for ur quick reply .

[#4]

Hi,

U can use the drill down using the all Levels.

Is it resolve ur issue?

Regards

Manesh.

[buzzy996]

not yet,by drill down all levels can not possible to chnage x-axis!

any help?

[#6]

try to use

=If(GetSelectedCount(Level4),Level1,If(GetSelectedCount(Level3),Level4,If(GetSelectedCount(Level2),Level3,If(GetSelectedCount(Level1),Level2,Level1))))

as a dimension

[ericcosmai]

Hi.

Follow what I got and the attached app...

=

If(GetSelectedCount(Level1)=0,
    if(GetSelectedCount(Level2)=0,
        if(GetSelectedCount(Level3)=0,
            Level1
        ,
            Level4
        )
    ,
        Level3
    )
,
    Level2
)

I hope it helps.

Regards.