1 Reply Latest reply: May 15, 2014 9:54 AM by Grant Perkins RSS

    Count Certain Records?

    Gene _

      I'm trying to find see if there is a way to use the count function in a summary to count only certain records.

       

      Here's what I have for data:

      A Cashier Number (numeric field)

      A Transaction Code (numeric field)

       

      Transaction Codes range from 5000-6000.

       

      Does anyone know how to create a summary that will show fields like this:

       

      Cashier Name

      1. of 5000 Transactions

      2. of 5001 Transactions

       

      and so on.....

       

      Thanks for any ideas,

      Gene

        • Count Certain Records?
          Grant Perkins

          Gene,

           

          I assume you have the data to translate the Cashier Number to a name?

           

          So a 2 column summary with name in the first column and transaction code in the second (sorted) would be close? Especially if the repeating values in the first column were suppressed? (I assume that the output format requirement is part of your concern. Indeed it may be your major concern.)

           

          Could you then simply use a filter to select only the codes you require and apply the count to transaction code field?

           

          Failing that, and depending upon the version you have (I can't remember if we have covered that in earlier posts) perhaps something in the 'matching' menu would be usable.

           

          I will be happy to play around with some sample data if it would help.

           

          All the best.

           

          Grant

           

          Originally posted by Gene:

          I'm trying to find see if there is a way to use the count function in a summary to count only certain records.

           

          Here's what I have for data:

          A Cashier Number (numeric field)

          A Transaction Code (numeric field)

           

          Transaction Codes range from 5000-6000.

           

          Does anyone know how to create a summary that will show fields like this:

           

          Cashier Name

          1. of 5000 Transactions

          2. of 5001 Transactions

           

          and so on.....

           

          Thanks for any ideas,

          Gene /b[/quote]