Forum Discussion
Getting Single Product Sales from Mixed Product
Hi I work in a Brewery and we sell mixed cases of beer alongside single beers. I'm looking for a way to split the mixed cases and show a total sales number for the individual beers. In Power Query ...
lbendlin
Super User
Super UserThank you for providing sample data. I see there is a conflict in the meaning of the "Product" field. In the Case Mix table "Product" is identifying the case type but in the transaction/bookkeeping data "Product" identifies the individual beer. Can you please clarify?
That'll be because the 2 lots of data come from the same master report. When we sell anything it goes under product sales.
I've duplicated our main bookkeeping report and filtered 1 by single products and the other by mixed cases.
My idea was this would give me 1 report to show single beer sales and a second that I would need to convert to single products and relate back to the single products to give me 1 report with all product sales.