Forum Discussion
Getting Single Product Sales from Mixed Product
Super UserI would assume that any beer can be sold in either a "clean" case (only that beer) or in a mixed case. In that case (sorry about the pun) there is no way to distinguish/decide which scenario to apply. Do you at least have a clean/mixed flag?
All products are sold from a category. The single beers are sold under 'Bottle and Cans', the single beer cases and '12 Pack' and the mixed cases are "Mixed Cases". I use the category to filter the sales into the 2 data sets.
For working out the single beer sales, I use the category name to work out how many units are sold from each product. 'Bottle and Can' equals 1 unit and '12 Pack' equal 12 units. Then multiply the quantity sold by the units. That gives me the total number of beers sold from the single units.