Hi,
I am trying to filter values based on selection from a drop down list in a way that if employee "B" is selected from dropdown list, table should show employee "B", his supervisor "A" and his direct reportees "C" and "D"
= IF([Supervisor ]='$(=GetFieldSelections(list))' OR [Employee]='$(=GetFieldSelections(list))'
OR [Employee]= (IF([Employee]='$(=GetFieldSelections(list))',[Supervisor ])),[Employee])
This expression is returning employee "B" and his reportees but not his supervisor
Looks like there is some issue in this part
[Employee]= (IF([Employee]='$(=GetFieldSelections(list))',[Supervisor ]))
Can you please help to resolve this
| Employee | Supervisor |
| A | |
| B | A |
| C | B |
| D | B |
| E | C |
