0 Replies Latest reply: Dec 11, 2017 3:44 AM by Monika M RSS

    Display set of particular expressions based on dimension

    Monika M

      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