Consolidate data from line item table to get total sale per order

Hey guys, I’m not sure how to do this, but I have a table where all sales are entered in an order line item format and I have a column for the invoice number field. I can’t change that because of how that’s exported from different distributors.

How do I sum up the $$ for each order line item based on invoice number so I can get a roll up and pull a report on average sale per customer?

thank you!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.