Can you Create a total in a Weldment cutlist and save it as a Template?

Evening all,

Im trying to create a weldment cutlist and BOM which show a TOTAL value for a column.

For example,

The BOM will show 5 parts in the assembly with quantity of 1 to each part. Can i edit my BOM so that a total is shown under the quantity cloumn? In this case 5.

You can do this manually using formulas but i was hoping that it would come through automatically. Maybe using an excel BOM?

Any ideas welcome!

Many thanks in advance.

Nick

SolidworksBill Of Materials