BOM table - Duplicates when adding weight

Hi all,

We have a BOM table set up that works fine (no duplicates) but when adding a column for the weight it brings back in the duplicates.

I guess this is to show the weight of each part and each individual duplicate part.

Is there a way to not show the duplicates and the weight column to show a weight for each part?

eg. if there is two of Item 5, the Qty column would show '2' but the Weight column would show the weight for one of Item 5?

Creo 8

Hope that makes sense.

Thanks