A soft-drink manufacturer produces several flavors of drink—for example, cola, orange, and lemon. Additionally, each flavor has several versions such as regular, diet, and caffeine-free. The manufacturer operates factories in several states.
Assume you have input records that list version, flavor, yearly production in gallons, and state (for example: Regular Cola 5000 Kansas). The records have been sorted in alphabetical order by version within flavor within state. Design the report that lists each version and flavor, with minor total production figures for each flavor and major total production figures for each state.
I am in need of a flowchart that will work for this scenario. Can anyone give me an example?