Pivot Table Group by one field but sum another

[mma40]

I have a pivot table that I need to sum the Number Affect by the Group
Date. Here is example of layout:

Site DATE EQUIPMENT NUMBER AFFECTED
MACON 38726 SHELF42703 1
38732 SHELF12703 14
SHELF12704 9
SHELF52703 10
SHELF52704 10
38737 SHELF62703 13
SHELF62704 5
SHELF72703 7
SHELF42703 1
38738 SHELF42703 1

Here is what I am trying to accomplish:

Site DATE EQUIPMENT NUMBER AFFECTED
MACON 38726 SHELF42703 1
38726 Sum of Number Affected 1
38732 SHELF12703 14
SHELF12704 9
SHELF52703 10
SHELF52704 10
38732 Sum of Number Affected 44
38737 SHELF62703 13
SHELF62704 5
SHELF72703 7
SHELF42703 1
38737 Sum of Number Affected 26
38738 SHELF42703 1
38738 Sum of Number Affected 1

Any help will be appreciated.

 

[Debra Dalgleish]

Double-click the Date field button, and under Subtotals, select Automatic.
Click OK

 

[mma40]

It is already set that way

 

[mma40]

Nevermind. I was using the wrong field to get the total. I figured I
was doing something wrong. Thank You