Cyclic Group on Dimension Axis

[#1]

Hi All,

Hope someone can help with this.. I have a cyclic group compromising of FiscalYear, QtrYear and ShipDate that I use in a Bar chart. I modified the Dimension axis for this chart,  adding "Min (FiscalYear) " and  "Max (FiscalYear) " to the Static Min and Max fields. As a result, when I cycle past the FiscalYear in my chart I get no data since the Axes are set to FiscalYear. How can I modify the axes to work with the Qtr and Month selections?

All help much appreciated

John

[sujeetsingh]

create another group with these added dimensions

[#3]

But even if I create another group, my Dimension Static Min and Static Max are still set to "Min (FiscalYear) " and  "Max (FiscalYear)" .. Is there an expression that I could use in the Static Min/Max box to dynamically allow the Cyclic group?

[#4]

Hi,

     sorry  but your question not clear.....are you adding two more field with cyclic group dimension??

Can you please attach any sample file?

Regards,

Ashutosh

[ngulliver]

One option would be to use buttons instead of cycle groups. The button could change the dimension and the Static Max /Min if they were all in variables.

Regards,

Neil