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 .




      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?