monkeyharris
Active Member
- Joined
- Jan 20, 2008
- Messages
- 346
- Office Version
- 365
- Platform
- Windows
Hope i can explain this properly. I've managed to find a way of getting the data (sort of) but when i go back over it i'm finding it hard to link the columns of A (branch), L (Primary Branch), M (Secondary Branch).
Below first table is a snapshot of weekly transport movements. Column A shows the branch who actually did the delivery. Column K shows the postcode this branch delivered to. We've allocated branches certain postcodes and i have a lookup that looks at "Del Postcode" and populates "Primary" and Secondary" automatically.
Now my problem is, in the second table i need to show results from the data. We've agreed branch 168 can deliver to certain postcodes allocated to branch 205, 205 has it's own postcodes so these need to be counted in the same manner. Not all postcodes have a secondary branch.
If it's easier i can send the workbook.
Below first table is a snapshot of weekly transport movements. Column A shows the branch who actually did the delivery. Column K shows the postcode this branch delivered to. We've allocated branches certain postcodes and i have a lookup that looks at "Del Postcode" and populates "Primary" and Secondary" automatically.
Now my problem is, in the second table i need to show results from the data. We've agreed branch 168 can deliver to certain postcodes allocated to branch 205, 205 has it's own postcodes so these need to be counted in the same manner. Not all postcodes have a secondary branch.
If it's easier i can send the workbook.
Branch | Customer Name | Account Code | Order No. | Order Value | Date Created | Delivery Date | Address 1 | Delivery Type | Vehicle Reg | Del Postcode | Primary Branch | Secondary Branch |
168 | Test | Test | Test | Test | Test | Test | Test | Delivery | DG64VUV | G42 | 206 | 205 |
168 | Test | Test | Test | Test | Test | Test | Test | Delivery | DG64VUV | G72 | 168 | 205 |
168 | Test | Test | Test | Test | Test | Test | Test | Delivery | DK66JZW | PA7 | 3988 | |
168 | Test | Test | Test | Test | Test | Test | Test | Delivery | DK66JZW | EH53 | 168 | 205 |
168 | Test | Test | Test | Test | Test | Test | Test | Delivery | DG64VUV | KA21 | 205 | |
168 | Test | Test | Test | Test | Test | Test | Test | Delivery | DG64VUV | KA21 | 205 | |
Branch Number | Total Deliveries | Compliant | Non-Compliant | Branch Performance |
168 & 205 | ||||
205 | ||||
206 | ||||
371 |