When I run a report for a particular Category there are many times I only want to see data on certain Variations of the Items in that Category. My business makes and sells beer and we divide sales of our beers into Variations such as Glasses, Cans and Growlers. Very often I need to see a report of only Cans, which is a Variation of a certain beer style. Here is an example:
Item
IPA
Variations
Large Glass
Small Glass
Can
Growler
Right now I have to work through every beer name (we have many) and write down the number of sales each Variation and then add it up manually.
