use one table to dynamic add dimensions in different charts with alternate state
I created several charts on several subjects. These charts can have the same dimensions to make a further specification (like, age, nationality, gender etc)
I want to give the user the possibility to add or remove a dimension without the other charts to be affected.
I loaded a table with the possible dimensions. These dimensions appear in a listbox.
My question: Is it possible to re-use the listbox, add an alternate state to it, and use that alternate state in the chart to specify which dimension has to be added ?
for example : add a calculated dimension like : = '[alternate state'& listboxvalue &']'
