Can the Merchandise Sales Report be filtered by Username?
I am LOVING the new merchandise sales reports, but the one problem I'm still having is finding a way to sort sales by username.
We have two different locations, as well as an "online store." I've previously used ad-hoc queries to track all merchandise sales, but now that the merchandise sales reports actually work, I'm hoping to discard the ad hoc queries.
I need both total sales for each username (which I know I can get through Total Revenue Reports) AND cost-of-good-sold for each. Is there any way to get the COGS per username?