Hi all, I have a map showing locations of customers linked to store locations. I have calculated the nearest store to each customer and can show the customer locations on the map but am unable to show the nearest store locations on the same map/
What I would like is to show both on the same map. The customers in 1 colour/symbol, and the nearest stores in another colour.
Is this possible?
I would then use a filter to select each customer to show their nearest store, or do this geographically by region etc.
I have attached the workbook as it is so far.
Thanks in advance.
6 answers
Hi, Naresh
Is it something like this? the shape star is the branches.
A snapshot of Midlands
Workbook attached.
Hope this helps
ZZ