1 Reply Latest reply: Aug 20, 2010 8:05 PM by Michael Brückner RSS

    "What percent of SALESPERSON 'A's'  sales are also covered by SALESPERSON B?"

      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!