Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Unanswered: count the number of occurrence in a pull-down list

    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
    Last edited by greenlearner; 03-10-09 at 22:56.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •