As a brewery, we have to report every drop of beer that we sell and in what package it is sold. So when we brew a beer, a new sales code is created and then 3 sub codes for cask, keg and bottle versions of that beer. When I run a monthly sales report, it would be great to be able to see how many of each unit was sold in each sub-code category. At present, I run a monthly sales report which gives me total sold for each sales code then have to drill down into each to extract the exact number of units sold of each packaging type.
If I run a report on an individual sales code, I get exactly the information I'm after - but then obviously have to run a large number of individual reports to get the information for every beer sold during a particular month.