AnsweredAssumed Answered

Counting The Number of Sub-Summary Fields with the Same Value

Question asked by gshank on Apr 5, 2011
Latest reply on Apr 5, 2011 by philmodjunk

Title

Counting The Number of Sub-Summary Fields with the Same Value

Post

Hello - I want to summary of sub-total of the number of "tickets" my customers have. I have individual records for each ticket with the customer's name and I have successfully created a summary report counting how many tickets each customer have earned -  it looks like...

  • David   24
  • Susan  19
  • Ann  10
  • Jill    10
  • Bob    5
  • Mary   4
  • Jack  4
  • Steve   4

As I am going to award prizes for the number of tickets they have, I want to count of how many at each leve so I can get an idea of the prize count...

  • 1 with 24
  • 1 with 19
  • 2 with 10
  • 1 with 5
  •  3 with 4

I can't seem to find out how to count a sub-summary field.  Any suggestions? Any help would be appreciated.

Outcomes