Show only data without duplicate

[Anonymous]

Employee               WorkID      Status

Adam                            1          Missing

Alex                              2          Approved

LIm                               3          Pending

Raja                              4          Pending

Singh                            5           Approved   

Adam                            6          Missing

Alex                              7          Approved

Lim                               8          Approved

What formula to use. If I want to produce below result. I dont want employee that have more than 1 id:

Employee          WorkID          Status

Lim                      3                    Pending

Raja                     4                    Pending

Singh                    5                   Approved

TQ,

[SunilChauhan]

in dimension  take Employee

and in expression:

if(Count( distinct  WorkID  )=1,Status)

expression --> if(Count( distinct  WorkID  )=1,Count( distinct  WorkID  ))

hope this helps