| Outcode | Neighbour | Distance | Adults |
| IP | CO | 20 | 2000 |
| CO | SS | 30 | 1000 |
| CO | EN | 50 | 5000 |
| BN | TN | 55 | 4500 |
| SS | WW | 40 | 3300 |
| EN | ZZ | 100 | 2200 |
TN | RR | 90 | 7000 |
I have the above table of postcode areas, the distance to their postcode area neighbours, and the number of adults in each postcode area.
I want a chart which shows (for a selection of postcode areas) the postcode area, its nearest neighbour, and the number of adults in that neighbour.
CO, SS, 3300
BN, TN, 7000
Ideas please ! Do I need set analysis ?
Thanks
