I'm trying to get a report together that will show the total of the transaction and how many items where bought if the transaction contains a certain UPC.
In our example, we want to know what the customer spent and bought if they used particular coupons last week.
I've come up with some, but the detailed reports in manager don't really allow me to see the total sales of the entire transaction. And it causes double reporting if the customer used two different coupons in the same transaction.
Does this make sense? Surely someone has wanted to see this information before...any ideas? Maybe I'm making this harder than it needs to be.
I appreciate your responses.