For the data set below
Company | employee | Plan | Status |
ABC | 1 | A | Inactive |
ABC | 1 | B | Active |
ABC | 2 | A | Active |
ABC | 3 | A | Inactive |
I'm trying to Filter the above data to return an active row when an employee exists in two plans (example employee 1 ). For all other employees with single plan return the row irrespective of status. Is there a function that can filter this ? Thanks
Expected result
Company | employee | Plan | Status |
ABC | 1 | B | Active |
ABC | 2 | A | Active |
ABC | 3 | A | Inactive |
¡Resuelto! Ir a solución.
Thank you for the solution . I observed in the last filter if I have to exclude more than one condition in custom filter
[status] != inactive or [status]!= terminated it does not seem to work. If I apply two different filter it gives me right data. any suggestion here. Thanks
Hi @AdithyaNaralasetty, using two negative conditions with an OR statement is not recommended as the logic can get twisted. I encourage you to use two separated filters or change you expression to something not using the negative condition.