Total Weight Column

Hi, on my BOM I have a weight column, but I have multiple parts that are the same. The weight column only give me the weight for one individual part. I want to add a column that will give me the total combine weight of all the same parts. Can some one give me any ideas on how I can do this, thank you.

SolidworksBill Of Materials