Can this be done?

 

For the example below the desired values in the dynamic parameter would be EmpNo which have Emp_Status = Active and have Emp_Type = Sales (EmpNo 1 and EmpNo 2)

 

EmpNo     Emp_Status     Emp_type

1              A                      Sales

2              A                      Sales

3              I                       Sales

4              A                      Prod

5              I                       Prod