Hi,
I have 3 columns Column A, Column B, Column C residing in same table. I need to create a filter with the distinct values of this 3 columns, and when I apply filter or select any particular value which belongs to Column A, the data should get filtered based on only Column A. Is this can be achieved?
Source Table
| A | B | C | D | E | F | G |
| aa1 | bb1 | cc1 | de | er | we | ok |
| aa2 | bb1 | cc2 | de | ert | df | jk |
| aa2 | bb1 | cc2 | ds | yt | vb | hjg |
| aa3 | bb2 | cc3 | dg | fd | kjl | ww |
Filter Needed in below format:
aa1
aa2
aa3
bb1
bb2
cc1
cc2
cc3
Output :
In the filter if I select value aa1, only the first row should get displayed.
