2 Replies Latest reply: Jul 28, 2010 5:08 PM by Ms. Shrestha RSS

    How to trigger macro when the changing dimension using Cyclic group

      Senario:

      I have a chart with fast change (Straight and Pivot) which is created dynamically. It contains many dimensions and one of them is a cyclic group which displays field (Date and Month-Year) . This chart is linked to a macro so that when users adds or removes dimensions it returns the number of row count.

      Issue: When switching from Month-Year to Date in cyclic group, I cannot find a way to trigger the macro to run that does the row count.

      Does anyone know how to trigger macro when the changing dimension using Cyclic group. I tried "On Active" trigger for the chart but it doesn't work either.

      Any suggestions will be appreciated.