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