Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Not quite clear... Hope I got it close enough to be helpful - see attached.
See attached qvw.
Thanks Gysbert ...It worked...