0

How do I retrieve 1 record when multiples exist?

I have a few different reports I'd like to write that I could use a little help with.
I'd like to show the sales per day (sales/profit/Gross Margin) by customer. The problem that I'm having is that in any given day, the same customer may have 2 or more invoices. I'd like my report to show the customer once, and the total for that customer, for that date range.
What is the missing code that will return the customer once, but show the combined invoices for that customer?
Here where I'm at right now, if anyone wouldn't mind putting in their 2 cents worth. Thanks!

=NL("rows=5","Sales Invoice Line","Sell-to Customer No.","Sell-to Customer No.",$D$2,"Shipment Date",$D$3)

3 comments

Please sign in to leave a comment.