SUM by Group in Query Generator

I need to group a column and then subtotal each group. The SUM function has not worked for me and I have not found anything in SQL documentation that works in SAP. Does anyone have an idea of syntax for subtotaling in a query?

Regards,

Jacquie