Do the two data sources have any common fields? You would need to do a data blend before you could have data from both sources on the same map:
If you're able to post the packaged workbook, someone may be able to help further.
The two data sets both have location fields like address, city, state, zip, latitude and longitude. Beyond that, they aren’t similar and don’t share attributes. We are trying to show the customers on the map along with the competitors. I’m assuming it would involve some sort of union of the datasets, but I can’t figure out how to do that.
Matt Dormond | Business Intelligence Specialist | Rumsey Electric
visit us @ www.rumsey.com<http://www.rumsey.com>
<http://www.facebook.com/#!/pages/Rumsey-Electric/129663577049040>[Description: Description: Description: cid:image002.jpg@01CC5829.E759D7B0]<http://www.linkedin.com/company/rumsey-electric-co.> <http://twitter.com/#!/RumseyElectric>
You could add a column that shows customer/competitor and merge the two excel files
Did you get an additional feedback? I also well are looking to map incurred values for a CAT and then policies in force information. I can data blend the zip code but they are really two different data points that I need to map together.
I am also wanting to do something like this. I need one map to show a state footprint and one that overlays or combines data based on zip code.