group by max value

[smg]

Hello,
I have the following query results. From here I need is to add up all the charge hours and group them by employee by the sched with the highest timesheet date so in this case the result would be EE1, FRITHUR, 58.2 hours. I'm struggling with how to do that without losing the hours for the SATFRI sched. Thanks

EE	SCHED	TimesheetDate	FY Year	Period	SubPeriod	Charge Hours
1	FRITHUR	2/19/2021	2021	5	3	0
1	FRITHUR	2/19/2021	2021	5	3	0
1	SATFRI	1/29/2021	2021	5	3	3.2
1	SATFRI	1/29/2021	2021	5	3	4
1	SATFRI	1/29/2021	2021	5	3	0
1	FRITHUR	2/19/2021	2021	5	3	0
1	FRITHUR	2/19/2021	2021	5	3	15
1	FRITHUR	2/19/2021	2021	5	3	28
1	FRITHUR	2/19/2021	2021	5	3	0
1	SATFRI	1/29/2021	2021	5	3	0
1	FRITHUR	2/19/2021	2021	5	3	0
1	FRITHUR	2/19/2021	2021	5	3	8
1	FRITHUR	2/19/2021	2021	5	3	4
1	SATFRI	1/29/2021	2021	5	3	-4

[Gicu]

Create a query that groups by EE and gets you Max(TimesheetDate). In another totals query group by EE, Sum(ChargeHours) and join the previous one by EE and bring in the SCHED.
Cheers,