I have now created the attached workbook with the help of a guide by Richard Leeke, which shows 852 points distributed around the UK, representing shop locations. I have applied the radius multiplier so I can change the radius around each shop from 1 to 6 miles to see if the radius around each shop overlaps that of a neighbouring shop.
This all looks good on the map but I need a table to go with this to show which shops and how many shops overlap with one another once a particular radius is set.
This will show me the effect of increasing radius and help direct marketing resources more efficiently for each shop.
I'm hoping someone can help with this project of mine.
Radius Circles NS v2.twbx 369.2 KB