conditional show of dimension in chart

[#1]

Is there a possibility for a conditional show of a dimension in a chart?

vVariable = x

Then I want to see dimension X in the chart

vVariable = y

I want to see dimension Y in the chart.

I'm searching for an automated solution.. no cyclic group.

[#2]

Creating a calculated dimension should do it

Regards,

Gordon

[#3]

Actually I'm trying to switch between two cyclic groups depending of the variable value.

=if(vVariable = 'x', Cyclic_group1, Cyclic_group2)

It isn't working.. any suggestions? Thanks!

[#4]

Just wondering if this was ever answered. I am looking to do the same thing as described above but am having little success.

[stevedark]

It would appear that you can not reference Cycle Group names in a Calculated Dimension.  However, what you may be able to do, depending on the number of dimensions etc., is to have a single Cycle Group for that column and have the fields in the cycle group be Expressions based on the variable.  This would depend on there being the same number of values in both cycle groups.

- Steve