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

Topic Labels: Formulas
470 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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!

0 Replies 0