Equivalent of MySQL Sum(X) group by Y in Crystal reports?

Question

This is how my report looks like now :

I'd like the Quantity summed up for each Product , similar to how we do it in a SQL query :

select product_id ,sum(quantity) from my_table group by product_id;

This is the desired output :

product	quantity
Aluminuim	204
Bois	216
Dynamo Bicyclette	36
Guidon Bicyclette	12
Necklace string	5,530

Answer 1

Another option is to simply insert a CrossTab. Use the Product as the row element and Quantity as the metric to sum.