Community Forum

# of Orders for the Day

Hello - Using the Sales Detail Report I can pivot by day however, I am getting a # of Orders Total that reflects the # of individual transactions. The same order number might be repeated three times for 3 indiv. bottles but I want my Pivot to count this as 1 Order not 3 Orders.
Does anyone have the formula?

Kindly - CGM

Welcome to the board, CGM!

You could try this:

https://www.sageintelligence.com/tips-and-tricks/2017/03/get-distinct-count-pivot-table/

Or just run an Orders by Ship/Pickup Date report.