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,
NP
