PROBLEM: I have a list of 500 CLIENTS and the 10 SALEPEOPLE serving those clients. Example below.
Client Salesperson Sales
1...500 A ...J $$$
QUESTION: I would like to answer the question...
"What percent of SALESPERSON 'A's' sales are also covered by SALESPERSON B?" or
"What percent of SALESPERSON 'A's' sales are also covered by SALESPERSON C AND D?
I'm wondering if concatenating of fields may be an approach but I'm hoping for something more elegant.
Any help is much appreciated. Thanks in advance!