Latest Date

[jenit92]

Hi All,

I have a table with the structure below:

Process Number	Date	Department Description
354152	05/10/2019 10:24:20 AM	IT
354152	05/10/2019 10:29:10 AM	Business
354152	05/10/2019 10:32:28 AM	Business
354152	06/10/2019 11:12:17 AM	Business
397814	07/11/2019 08:01:20 AM	IT
397814	07/11/2019 09:11:24 AM	IT
397814	07/11/2019 09:19:20 AM	HR
397814	07/12/2019 08:01:20 AM	HR

What I want is to get the latest date of specific process number for each department. 

For example:

for process number 354152 the latest date in Business that is 06/10/2019 11:12:17 AM.

for process number 397814 the latest date in IT that is 07/11/2019 09:11:24 AM, the latest date in HR that is 07/12/2019 08:01:20 AM.

I have tried to use the MAXX function but it gives me the latest date for entire process and I want the latest date for specific department.

Thanks