How do I have a dynamic dimension in a cyclic group?

[#1]

Hi. I have a qvw file where I allow the users to switch between fiscal and calendar years. The selection is stored in a variable and I use the following calculated dimension in my charts to display either date dimension depending on the selection.

if(vViewMode='Fiscal',FiscalPeriod,Month)

I'm trying to use the same calculated dimension in a cyclic group but I just get  '-' instead of the dimension. What am I doing wrong?

Thanks in advance.

[Nicole-Smith]

If you're using a cyclic group for your dimension, you shouldn't use the calculated dimension you have listed above.  You should have two dimensions in the cyclic group: one being FiscalPeriod and the other being Month.

[#3]

Thanks for replying but I'd rather the users didn't have to cycle through options they didn't want.

[#4 · Accepted solution]

Hurrah. I've just figured out how to do it!

I've created a variable vViewMonth with the following value

=if(vViewMode='Fiscal','FiscalPeriod','Month')

I then set the dimension in the group to be =$(vViewMonth) and the label to =vViewMonth