Hello,

Please help and advice how to count the number of occurrence in a pull-down list. This list has our SALESMAN's name (5 of them). And each JOB has only one SALESMAN. We have hundreds of JOBs for different CLIENTs.

I have made a summary report and have sorted and listed all the CLIENT with their sales amount from the highest to their lowest using “Sub-summary when sorted by: (CLIENT and SALESAMOUNT)”. I have also listed the number of job each CLIENT has done by counting each (JOB). But I am having trouble listing the number of job each salesman are responsible under the same line for the client.

Example:

Client-----Sales Amount-----Job-----SM1----SM2----SM3----SM4----SM5

abc-------$800,000---------230------66------75-------9------55-----25
def------- $ 52,000----------60-------0------20------40-------0------0


SALESMAN = SM1, SM2, SM3, SM4, SM5 (I have trouble listing the number of job each salesman is doing for each client.

Please help.

Thank you
greenlearner