Show Each Employees' the Latest Some Entries

[camellia26]

I have to check each employees' daily reports every day. I made a summary view of daily reports but hope to filter them by the latest three reports of each employees. How can I realize it?

AS-IS:

A view I can check EVERY daily reports of all employees.

TO-BE:

A view I can see the latest three reports of each employees.

MAXROW() seems to be good but it returns only the newest row.

MAXROW() - AppSheet Help

[Marc_Dillon · Accepted solution]

IN(  [key] , TOP( ORDERBY( FILTER( ... , [employee]=[_THISROW].[employee] ) , [rownumber]/[timestamp] , descending ) , 3 )

[camellia26]

Thanks Marc, that works fine. I wrote like below.

IN([UID], TOP(ORDERBY(FILTER("TargetTable", [enployee_id] = [_THISROW].[employee_id]),[date], TRUE), 3))