I think I understand. For example, only sum them if they are wood, steel, etc. right?
To do this, use a calculation field on the line item.
If(type = "steel" ; total ; 0)
Then in the invoices table, create a sum field on that calculation field.
Thank you so much! That works brilliant! Exactly what I wanted to do. :smileyvery-happy: