Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
709 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Mariane_Marketi
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