First and Last Date of filtered interval

[marpisa]

Hi everybody,

I have this situation:

Day	Person	Project	Hours
01/01/2021	Marco	Alpha	4
02/01/2021	Marco	Beta	4
02/01/2021	Marco	Alpha	8
04/05/2021	Marco	Alpha	4
01/03/2021	Marco	Beta	4

My aim is to have for each project / person the total number of hours and the first and last date of work.

Something like this

Person	Project	Hours	First Date	Last Date
Marco	Alpha	12	01/01/2021	04/05/2021
Marco	Beta	8	02/01/2021	01/03/2021

how can I do?

Thanks

Marco

[amitchandak · Accepted solution]

@marpisa , In a table of Matrix, take you can person and project on row. Sum of the hour as value and min and max of Day as first and last date

But why the first on is 12 not 16?