What I'm trying to do is create a dynamic filter 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
Ex1: Filter1 ....A
Filter2 ....{A,B,C}
Ex2: Filter1 ....B
Filter2 ....{1,2,3}
Please suggest...Currently I'm using following expression for filter 2 which is displaying all possible values which is not our requirement
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 |
