Dynamic Filter issue

Fri, 20 Dec 2013 13:41:20 GMT

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

Re: Dynamic Filter issue

Anonymous — Fri, 20 Dec 2013 16:33:26 GMT

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

Gysbert_Wassenaar — Fri, 20 Dec 2013 16:38:40 GMT

See attached qvw.

Tue, 24 Dec 2013 09:57:08 GMT

Thanks Gysbert ...It worked...