6 Replies Latest reply: Feb 20, 2014 11:26 AM by Jessica Ben RSS

    Control cyclic group using Button

      Is it possible to control a cyclic group using a button other than the standard button inside the chart? If so, how? I would also want to remove the button within the chart.

       

      I have 3 tables on one sheet. Each chart uses a different expression, but that all use the same group to modify the dimension. I want to have a single button that can be pressed to control which group is active on all 3 charts.

       

      Simplified example below:

       

      Buttons:

      [By Customer]    [By Product]     [By Region]

       

      Charts:

      Chart shows total sales (by either Customer, Product or Region)

       

      Chart shows total hours (by either Customer, Product or Region)

       

      Chart shows total transactions (by either Customer, Product or Region)