How to show latest Record in table

[Rajesh]

Hi All,

I trying to create one table to show employees latest record based on Last_Worked_Date date field.

below is the sample data image:

and Expected Out put Image is below: ( Need to achieve in front end)

i have took dimension are : Name, Job title, Prod_name, ulti_parent, resi_state, Division

Expression field:(Last Worked Date) :   Max({<LAST_WORKED_DATE={">=$(=Addmonths(Max(Today()),-13))<=$(=Addmonths(Max(Today()),-1))"},Job_title={"*ACC*"}>} LAST_WORKED_DATE)

here the issue is when i adding dimensions like Prod_name, ulti_parent, resi_state, Division  the data is showing multiple rows for one employee, if i dont add it showing expected records.

but i need to show this columns also in table as per client requirement.

Can u Plz find attached sample data excel and advise me the solution.

Thanks,

Rajesh.

[Rajesh · Accepted solution]

at last its worked out on my new expression.😊

Expression field:(Last Worked Date) : 

=Date(max({<LAST_WORKED_DATE={">=$(=Addmonths(Max(Today()),-13))<=$(=Addmonths(Max(Today()),-1))"},Job_title={"*ACC*"}>}Aggr(Max({<LAST_WORKED_DATE={">=$(=Addmonths(Max(Today()),-13))<=$(=Addmonths(Max(Today()),-1))"},Job_title={"*ACC*"}>}LAST_WORKED_DATE),NAME)))

Thank u

Rajesh