How to sum (group into one) same prducts and show total

[#1]

Hi,

I need to show a table box that lists the recordes of a product an its amount in stock. However there are many entries for each product. E.g.

X19920 - 234 pcs.
X19920 - 14 pcs.
X12332 - 10 pcs.
X12332 - 3 pcs.
X12332 - 2 pcs..

However, the table should shoow only *one* product per line an the total amount (pieces in stock).

X19920 - 2484 pcs.
X12332 - 15 pcs.

How can this be done?

Regards,

George

[Miguel_Angel_Baeyens · Accepted solution]

You can always do a straight table with Product Name as Dimension and Sum(Quantity) as Expression. That should work.