need to get the count records

[pinkpoppy]

I have a report displaying by groups, but I need the total count of records displayed.
Example data:

[b]Group 1: State   Group 2: Last Name[/b]
NM                        Smith  
NM                        Benson

GA                        Richardson
GA                        Floyd
GA                        Daniels

NY                        Robertson
NY                        Hawkins

PA                         Lee
PA]                        Smith

I need to display the total count: 9 records.

 

[kray4660]

Have you tried creating a Summary object (Sigma icon on tool bar) that does a count?

 

[pinkpoppy]

Yes, but it is not getting the right count.

 

[pinkpoppy]

It is counting the total number of records there are instead of 9 that I need.

 

[kray4660]

I am assuming that you are hiding the details. I believe you should be able to do a running total (count) that evaluates on a change of group.

 

[pinkpoppy]

thanks! it is displaying the right number now.