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.