Please see attachment...
I have a list of employees and the states they are assigned...the way the assigned states are listed is just like the example...one state per row (it will go down for all 50 states and contain additional employees, I just truncated the example here for simplicity)
Then I have a list of the states and the customers that have locations in those states. I need to show a list of all customers assigned to employee's states, and the number of locations in just those states. Any suggestions?
I appreciate the assistance...
Bookmarks