Pivot table grouping

[nc]

How do I group the dates of the pivottable below into
months?

Thanks.

Sum of Amounts
Date Total
01/08/2004 29,460.84
12/08/2004
31/08/2004 4,283.27
20/09/2004 -5,188.57
30/09/2004 -94.03
06/10/2004 -90,135.00
25/10/2004 -13,804.63
01/11/2004
03/11/2004 0.00
04/11/2004 10,686.90
10/11/2004 0.00
15/11/2004 131,116.49
20/12/2004 -5,376.63
30/12/2004 -3.76

 

[CarlosAntenna]

I do this by adding a column to my data with the formula =month(cell
reference for the date field) then use the month field in the pivot table in
place of Date.

Carlos

 

[Debra Dalgleish]

Right-click the Date field button.
Choose Group and Show Detail > Group
In the Grouping dialog box, select Months.
To limit the dates that are grouped, you can set a Start and End date
Click OK

There are instructions here:

http://www.contextures.com/xlPivot07.html

 

[nc]

Thanks Debra.

My error, I had a space as part of the date field.