I am working on a saved search to show SKUs sold by Item Family
So if the information was:
Family 1 : Total 15
SKU 1: 5
SKU 2: 10
Family 2: Total 3
SKU 3: 3
I want it to come out like this:
(SKU - Amount of SKU sold - Amount of Item Family the SKU belongs to)
SKU 1: 5 15
SKU 2: 10 15
SKU 3: 3 3
The search is pulling quantities from Cash Sales, Invoices, and Return Authorizations