I'm not sure of the the correct terminology here, so hopefully I can explain this properly.
I have a map with a large number of city locations. Product qty goes in the size field, while product type is represented by color.
The problem I am having is when I end up with a location that has multiple product types (colors). Sometimes only one color will show, other times it is both. If only one color is possible, I would have expected the larger qty to be shown, but that doesn't even hold true much of the time. There doesn't appear to be any rhyme or reason to it.
Any thoughts on how to fix this? We are looking at trends over a large area and if we can't get a reliable relationship between color and size it kind of defeats the point of creating the map in the first place.