I'm using google maps in an application and it works fine. But now I would like to add competitor locations to the map. These are loaded from an excelfile. It works independently from each other.
I don't want the competitors to be shown in th choices I just want them to show up as black dots on the map. I tried adding another longitude and latitude expressions but the scatter chart can only read a maximum of two expressions so the competitors doesn't plot.
also tried joining everything but then I get the problem of mixed competitors and our own in the same listbox.
Thinking of maybe using set analysis but haven't figured out how.