I'm trying to build a chart that shows "sales totals" by Month by Location by Product Category... can't figure out how to structure it. Basically, I want facilities grouped by month and then sales by category in the stacked bar. I can't see how to control the groupings to get this to happen. (I'm new)
Series (stacked bar): Product Category sales subtotals
Groupings : all 5 locations grouped by month