Formula to count number of items in a group individually

[austin22]

I am using Crystal Report 8.5 and I need your advise on how to retrieve a total within a group. Here is my set up:

Month Number of Warrant

October 2006 628
November 2006 1095(this number is incorrect...it should be 467)

I have it set up as a Running Total, Field to summarize = {Table.Case Number} and formula used = {Table.Balance Due}=0

What is happening is the number of warrants is just keeping a running total.

I want an actual count for each month...example Oct 2006 equals 628 and Nov 2006 equals 467

Not

Oct 2006 = 628
Nov 2006 = 1095(Adding the actual count (which is 467) to the previous count).

I hope this makes sense.

Thank you in advance for your advise or any help that you can render.

austin22

 

[synapsevampire]

Select reset for each month field.

This assumes that you are grouped by the date/month.

-k

 

[austin22]

Thank you so much. That worked! Have a great day.