Calculated dimension if-sentence

[#1]

Hello,

I have two Groups DBoardL and DboardG that include different fields.

Depending on the value of variable vP1 would I use one of the Groups,

but it doesn´t work. What do I do wrong?

if(vP1='21',DBoardL,DBoardG)

kindly

Håkan

[#2]

Yes, That's true

You won't get drilldown

[PradeepReddy]

We can achieve this by taking the 2 groups as 2 dimensions and applying the conditions to enable them.

1) Group1 dimension

    V='1' (In enable condition )

2) Group 2 dimension

    V<>'1' (In enable condition )

Note: Don't use the IF condition here.

See the same in the attachment. It is working fine for me.

Thanks

Pradeep