Averages by groups? VB.Net 2005 & Crystal

I fixed my previous problem, but have since ran across this.

My report looks something like this:

Location #1
ID1 ItemsSold TotalPay
ID2 ItemsSold TotalPay
ID3 ItemsSold TotalPay
*** SummedItemsSold SummedPayForGroup
Location #2
ID1 ItemsSold TotalPay
ID2 ItemsSold TotalPay
ID3 ItemsSold TotalPay
*** SummedItemsSold SummedPayForGroup

GrandTotal *** GrandItemsSold GrandTotalPay

I am figuring the GrandTotal fine...it's the lines with the sums of ONLY the group items that I am having problems with. They reside in the Group Footer Section 1 area of the report. Any help on how to total them correctly?Is it giving a grand total for the group totals

how is the groups totals incorrect.|||The grand total is giving the sum of all items and a sum of all pay. Those are the correct numbers I am wanting to show. The footer sums are only showing the pay total for one record(the maximum pay record). I tried using a running total, but I am not sure which to use.|||I was able to set up a CR that displays

Group Header (Location)
Details (value)
Group Footer Total of (value) per location
GrandTotal

I did this for the footers the same as I did for the GrandTotal.

when I selected the sum tool button I then changed the Summary location to group #1
this created a field for the group footer to total the value per group.|||I am able to get to where you are up until the point where I pick the field to summarize. The calculations to summarize by are:

Max
Min
Count
Distinct Count
Mode
Nth Largest
Nth Smallest
Nth Most Frequent

I am wanting it to add the totals for the group, and i am not seeing that as available. What am I doing wrong?|||This is something with the type of field you are trying to sum.
I went in to my example and changed my value field to a date field or a string field and it only gave me the options that you show.