I have a table that is grouped by Invoice Number. each invoice shows the product and the components that makeup the product.
I also have invoice totals, and grand total of all invoices
I wan to add total of component 1 and total of component 2
Not sure how to do this. any suggestions would be appreciated, thank you.