Multiple Field values in Single filter- How can we make it associative

[new_user30]

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.

[manoranjan_d]

its meeting as per above thread which i shared