so I created a cyclic group for A & B, and another Cyclic group for A1 and B1, so when I select from A from cyclic group1, the chart has to show values of A and A1 i.e sum and count , the same goes when I select B
Hi John, I don't know a way to know wich expression is selected in the group, can be donde by macro but changing expression doesn't launch a trigger for the macro.
As a workaround you can create a field with the values the user can select, checking 'allways one value selected' and use conditional expressions based on this field value. I usually use HidePrefix to name those fields used only as slector.
Another way is using buttons to change the value of a variable, and based on that variable make the conditional expression.
