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