Latest record should show on Date field and multiple Dimensions

[Rajesh]

Hi All,

I trying to create one table which shows the Last_worked_date of each employee as a one row (Latest)

my Dimensions and Measures are like below

Name, job_title, email, last_worked_Date, division, production_name 

expression: =Max({<LAST_WORKED_DATE={">=$(=Addmonths(Max(Today()),-13))<=$(=Addmonths(Max(Today()),-1))"},job_title={"*ACC*"}>} LAST_WORKED_DATE)

but it showing like below two or more records for one person, instead i should show only one record the latest one as highlighted one.

Date column in MM/DD/YYYY format

Can any one suggest me on this please.

Thanks in advance

-Rajesh.