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!