Hi ,
I have created a cyclic group using 3 dimensions , for example Dim A, Dim B and Dim C and giving a name to group Dynamic.
I am using this cyclic group in couple of my charts.
Now with the help of one button i am toggling the values,Like when i click on the button the value of Dynamic group would change from Dim A to Dim B then again on click it will change to Dim C.
Below is the logic i am using;
create variable (i.e. vButton), assign default value to 1
create button with action - set variable, variable: vButton, value: =if($(vButton)=1,2,if($(vButton)=2,3,1))
create cyclic group (Edit groups) with 3 Used Fields and
=if($(vButton)=1,DIM A,if($(vButton)=2,DIM B,DIM C))
Now my requirement is , i want to create a list box consist of Dim A,Dim B and Dim C and
select dimension values from list box instead of togging using button.
So i created a inline table
LOAD * INLINE [
ValueList, Flag
Dim A,1
Dim B,2
Dim C,3
];
and created a list box ValueList, now the challenge is to associate Value of ValueList with actual Dimensions .
Please advise.
