How to filter out the users by adding department number filter/by writing calculation?

[mkn23]

Hi All,

Could you please help me with the below scenario:

In this below example user XXX is part of 10 & 20 Department if user will add department number !=10 as a filter  then the result set is 20 - XXX - XXX@ and 20 - ZZZ - ZZZ@.

But user is expecting only 20 - ZZZ - ZZZ@ should be the output as XXX is part of 2 departments

Dept No	Ename	Email
10	XXX	XXX@
10	YYY	YYY@
20	XXX	XXX@
20	ZZZ	ZZZ@

.

User Expected out after applying the filter department number!=10 

Dept No	Ename	Email
20	ZZZ	ZZZ@