Dynamic Filter issue

[#1]

What I'm trying to do is create a dynamic filter2 where filter1 is created as Type ={A,B,C} as values using inline table...

Suppose if I select Type as A.....Only {A,B,C} possible values should be available in next filter(Currently im seeing all values)

Ex1: Filter1 ....A

        Filter2 ....{A,B,C}

Ex2: Filter1 ....B

     Filter2 ....{1,2,3}

Please suggest...Expression used for Filter 2

Filter2 =if(Type ='A',[Column A],if(Type= 'B',,[Column B],[Column C]))

Data is shown below

Column A	Column B	Column C
A	1	Y
A	2	Y
A	3	Y
A	4	Y
A	5	N
A	6	N
B	1	Y
B	2	Y
B	3	Y
B	4	Y
B	5	N
B	6	N
C	1	Y
C	2	Y
C	3	Y
C	4	Y
C	5	N
C	6	N

[Anonymous]

Not quite clear...  Hope I got it close enough to be helpful - see attached.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#4]

Thanks Gysbert ...It worked...