Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
Date Selection for Pivot Table | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |