I've a created a chart with cyclic groups in X-axis and Y-axis, so I could change my dimensions & measures. Then I've copied the same chart and pasted below (Replica of the 1st chart).
When I change the dimension (x-axis) in any of the chart its reflecting in both the charts. But its not changing for the mesures (y-axis).
I want to create a way in that if I change dimension/measure, it should reflect in both the charts. Find the attachment.
The dimension group is document wide and a change in one place will reflect in other objects. The expression group is object specific and updates in one object will not reflect in others.
If one is tricky enough it might be possible to make a decent solution using a macro with the CycleExpPos member but it's probably gonna get messy to sort out.
How to capture the "definition" (formula) / "column name" in the expression for the 1st chart? So that I could store it in a variable and use it in the 2nd chart.
Actually I can't think of any since you can't trigger a macro on cycling the expression in an object. Load the expressions in a separate fields to select from and then just call the fieldname as expression in the charts perhaps. No use of expression groups.
No, If I load the expression in a separate field it should appear outside the chart. But i want everthing should appear as a cyclic group.
My requirement is if I modify the expression in the 1st chart, 2nd chart will reflect. (I'll not modify the 2nd chart). What are all the other methods to achieve this?
The easiest way I can think of is to create an indicator use that in your expression, instead of the y-axis cyclic group in both the charts. Please refer to the attach example.
