Anyone familiar with pulling unit sales data toget...
# general
j
Anyone familiar with pulling unit sales data together with item numbers and kits that use the underlying item number? eg. we sold 10 of item A and 10 of kit B (each kit comprised of 2 item A) = 30 total units of item A sold We're finding it difficult to measure true sales velocity outside of downloading sales info into excel, and then utilizing the "member item" fields to add the quantities together.
b
You can use formulas and summary columns in a search to group member item rows and inventory item rows together
And then sum their quantities
j
ok, thanks, i'll check that out