How to group by Sum in a list or table Collection

[b2p]

Hi,
I’m stuck with a simple case I guess…
Here is my table:

I would like to display the total quantity for each item or even, avoid to repeat each occurrence of each item. I tried to use the Group by option but not sure it’s the right method.

I suppose there is a way to calculate the total quantity in the table but I don’t know how to do that.
If someone can help me with that…
Thanks in advance.

[Jeff_Hager]

Create a multiple relation linking Name to itself. Then create a Rollup column that uses the relation to sum the Quantity.

To address the duplicates, add a Row ID column. Then create a Single Value column the retrieves the first RowID from the relation. Only show rows where the Row ID column matches the Single Value column.

[b2p]

Jeff,
That’s fine. It works like I want.
Thanks a lot for your help.