Add (sum) column value with condition

[Chichap]

I need assistance on glide how can I get the sum value of a column base on a condition.
My product column has products (with similar names) Id like to get the total amount $ base on the product name. On screenshot I need to get the sum of all shampoo product. I dont see any filtering to do it or not either under the rollup.

if in another statement,
select productname where it is equal to this value, then add this column value (im not sure if it makes sense)

Any guidance is appreciated.

[Darren_Murphy]

• Create a multiple relation column that matches the Product Name to itself.
• Then use a Rollup Column to get a sum of values from that relation.

[Chichap]

thanks for the advise and will explore more for the relational column, and will update here
cheers!

[Chichap]

You are a superstar! It works.
Thanks so much!