Hi All
I have a query. I am trying to create visualizations where in I have 5 drill down dimension sets which are added to master items.
I have created a pie chart by adding all these master item drill down dimensions as alternate dimensions to the chart.
I have created a variable with the list of measures. Each dimension will be applicable to only 2 measures.
To represent them in figures:
DimA
DimB
DimC
DimD
DimE
Measure1
MeasureA
MeasureB
MeasureC
MeasureD
MeasureE
When DimA is selected in the chart, the variable drop down should show only Measure1 and MeasureA as selections, when DimB is selected in the chart Measure1 and MeasureB should be shown as selections in variable drop downs and so on
Can anybody help me out with the solution