Thanks Tracy! I think that should support what I want to do.
Tracy, I'm having a similar issue, but with a twist: What if you want to show ALL of the areas/groups, even if no sales occurred there.
For example, in the fixed sheet that you sent back, select "LAMBORGHINI" as the Make. Areas where there are no sales disappear, which isn't desired.
Analysis | Table Layout | Show Empty Rows doesn't rectify the problem.
Do you have any ideas?
The issue with this is that there is no data at all for Lamborghini, in say, Bakersfield, CA. So there is nothing to show--not even the fact that it had no sales. For this to appear, a row will need to be added to the data source with the DMA being Bakersfield and the Make being Lamborghini. Hope this makes sense!