I have data for 15 cities that I would like to stack in a bar graph (15 total bars). I have 30 measures total, with 2 categories of "sales" (in dollars) per city. I would like to stack these so that there are 15 bars each with two sums making up a total.
For instance, I would like Boston metal sales total and Boston brick sales total to be one bar, and Baltimore metal sales total/brick sales total to be another bar. I can't figure out how to combine the two sales into one bar.