button to switch dimensions in dimension groups

[#1]

Dear all,

is it possible to have one big button to switch within dimensions in one dimension group?

If I select the dimension group, I can actually select the dimension values (the specific weeks or months)

meanwhile I would like to be able to select group week or month!

thank you!

[rustyfishbones]

Hi Eric,

You can do this using a macro, see below, assuming here that the cyclic group is called g_DateSelection

SUB grbutton

SET gg = ActiveDocument.GetGroup("g_DateSelection")

gg.cycle 1

END SUB

You can then create a button, add an External Action, Run Macro and then add the name of the macro, in this case grbutton

[rustyfishbones]

Here is a sample file that can help you

[Anonymous]

Hi Erik,

You can use cyclic groups or Drill down groups to change dimensions without changing user selections.

Object properties - Dimension Tab - Click edit group - Click add button -select Cyclic or drill down group radio button - select dimensions and click ok - click ok and select Group created and click ok in Dimension tab

Now you can change dimension by clicking on Cyclic or drill down group icon in the charts.

[#5]

I actually

created an additional chart, where I boosted the font size for the legend.

I set transparent all the possible (background, frame, expression column)

removed title, set expression =1

so I am just left with a gigantic cyclic group button, which I can place strategically in a visible position

but thanks for your input!

[kevinpintokpa]

An unusual and innovative solution

[sunny_talwar]

Hey Alan,

I see that this Macro runs perfectly. Would you be able to explain what exactly it is doing here?

SET gg = ActiveDocument.GetGroup("g_DateSelection")

gg.cycle 1

How exactly is this switching/toggling between the fields in the cycle group?

Thanks

S

[koresaket]

I need to apply the same functionality on drill down group. Please suggest me some solution.