Pivot table grouping
 

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

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

"nc" wrote in message
...
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

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 he

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

nc wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks Debra.

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


-----Original Message-----
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 he

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

nc wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.