Dimension groups in a calculated dimension

[Anonymous]

Hey

Is it possible to use dimension Groups in a calculated dimension?

I want to calculate a dimension where I use dimensiongroup1 if the variable var1 = 1 and dimensiongroup2 if var1 = 2.

But when I try to set this calculated dimension up in a bar chart, I can only choose fields inside this IF statement, and not any dimension Groups I may have specified.

=if(var1 = 1,DimensionGroup1, If(var1 = 2, DimensionGroup2))

Are there anyone who can help with this?

/Michael

[JonnyPoole]

You can .  But wrap the group names in [] brackets.

=if(var1 = 1,[DimensionGroup1], If(var1 = 2, [DimensionGroup2]))

Also test with $(var1)   ... dollar sign expansion if you aren't getting the desired results.

Alternatively, you could also add both groups to the dimensions and do a conditional show/hide on each dimension so that only 1 is used conditionally

[sunny_talwar · Accepted solution]

I guess you mean cycle or drill down groups when you say "dimension group"? If yes, then you might be able to do what you have listed or you can add both your groups as dimension and make them condition.

for DimensionGroup1 use the condition var1 = 1 and

for DimesnionGroup2 use the condition var1 =2

I hope this helps.

Best,

Sunny

[Anonymous]

Cool, thanks alot. I will go for the show/hide option.

Best,

Michael