How to trigger macro when the changing dimension using Cyclic group
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.