Set Analysis on Dimensions

[linna]

Hi All,

I am developing an app and wondering how should I do a set analysis on dimensions.

I have a filter field [Employee Name]

My table has fields [Employee Name], [Employee ID], [Supervisor ID], [2nd Supervisor ID]

How can I make the table show all employees if the filter selected value's corresponding Employee ID is within [Supervisor ID] or [2nd Supervisor ID]?

Thanks!

[abhijitnalekar]

Hi @linna,

Can you please explain the scenario with an example, table representation would be helpful 

[anat]

can u try below calculated dimension...

if([Employee ID]= [Supervisor ID] and [Employee ID]= [2nd Supervisor ID],[Employee Name])