Show Start & Stop date and Sum Actual Hours used base on Phase on a Table

[Dante_83]

Hello Experts,

I want to show the [Start Date] & [End Date] and sum [Sched Hrs]  & [Act Hrs] base on [Phase] name? Below is an example of my data. 

Phase	Start Date	Stop Date	Sche Hrs	Act Hrs
Induc	07-May-2021	08-May-2021	4	5
Induc	08-May-2021	09-May-2021	4	3
Induc	09-May-2021	10-May-2021	4	4
Induc	10-May-2021	11-May-2021	4	3
Induc	11-May-2021	12-May-2021	4	5
Induc	12-May-2021	13-May-2021	4	4
Induc	13-May-2021	14-May-2021	4	3
Induc	14-May-2021	15-May-2021	4	5
Induc	15-May-2021	16-May-2021	4	3
Induc	16-May-2021	17-May-2021	4	2
Inspect	17-May-2021	18-May-2021	2	2
Inspect	18-May-2021	19-May-2021	2	2
Inspect	19-May-2021	20-May-2021	2	2
Inspect	20-May-2021	21-May-2021	2	2
Repair	21-May-2021	22-May-2021	10	13
Repair	22-May-2021	23-May-2021	10	4
Repair	23-May-2021	24-May-2021	10	10
Repair	24-May-2021	25-May-2021	10	12
Repair	25-May-2021	26-May-2021	10	6
Repair	26-May-2021	27-May-2021	10	10
Test	27-May-2021	28-May-2021	20	15

I want my table to look like the table below. Under [Phase], the Row Indoc, Inspect, Repair, and Test shows only the First [Start Date] and Last [End Date]. Also, the [Sche Hrs] and [Act Hrs] are sum. Does anyone know if this is possible? I really appreciate any help you can provide.

Phase	Start Date	Stop Date	Sche Hrs	Act Hrs
Induc	07-May-2021	17-May-2021	40	37
Inspect	17-May-2021	21-May-2021	8	8
Repair	21-May-2021	27-May-2021	60	55
Test	27-May-2021	28-May-2021	20	15

[BrunPierre · Accepted solution]

Expressions

Start Date - Min([Start Date])

Stop Date - Max([Stop Date])

Sche Hrs - SUM({<Phase={'Induc','Inspect','Repair','Test'}>}[Sche Hrs])

Act Hrs - SUM({<Phase={'Induc','Inspect','Repair','Test'}>}[Act Hrs])

Output

[Dante_83]

Peter,

Thank you so much for your help! The Expression work.