Pivot Table Group by one field but sum another

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.

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

mma40 wrote:
> 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
Contextures
http://www.contextures.com/tiptech.html

It is already set that way

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