I have the current script to generate a report:

2. spreadsheet  Hours_Report_for_Wages_II
3. {
4.     displayname = "Hours Report for Wages (II)"
5.     show  all  rows  from  Employee_Time_Sheet 
6.     (
7.         Name
8.         Hours
9.     )
10.     filters 
11.     (
12.         Date_field
13.         "Last Week Hours Only"  :  Date_field in last 7 days
14.     )
15.     group by
16.     (
17.         Name   ascending
18.     )
20. }

Can anyone help me with how I edit this script to the report only shows one row per Name and the total number of Hours recorded for them?

Thanks!