6 Replies Latest reply: Apr 5, 2017 8:22 AM by Sunny Talwar RSS

    Listboxes : to be populated based on dependant values in a column

    Sri Priya

      Hello All,

       

      I have a scenario where the filters in my report are to be created as List Boxes, which are actually values in one column .

       

      Example:

       

      A table say Fruits has the below columns

       

      Attribute , Value

      Season, Summer

      Season, Winter

      Season, Spring

      Color, Red

      Color, Green

      Color, Yellow

       

      Along with these two columns, there are other columns which may tell the fruit name its description etc.

       

      Now, we want to show the dimension as Color & Season

       

      So Select distinct value where attribute =’Season’ is our Dimension1

      Select distinct value where attribute =’Color’ is our Dimension2

       

      What is the best way to achieve this?

       

      Thanks!