grouping data in a pivot table
 

Hello I have a excel spreadsheet that I need to change into a pivot table.
The dates are listed in the date column daily. (1/1/01= $10 , 1/2/01= $
10,1/3/01= 10) I want the pivot table to group the dates and give me the sums
of a specific month. Jan 01 = $30. The reason I need to do this is because
the pivot table is also stating that I have too many columns and it wont
show all of my data at one time.

If you have real dates in that column, you can group that field by month (and
year) inside the pivottable.

Just rightclick on the field and choose "Group and show detail". Group by
months (and years??).



William wrote:

Hello I have a excel spreadsheet that I need to change into a pivot table.
The dates are listed in the date column daily. (1/1/01= $10 , 1/2/01= $
10,1/3/01= 10) I want the pivot table to group the dates and give me the sums
of a specific month. Jan 01 = $30. The reason I need to do this is because
the pivot table is also stating that I have too many columns and it wont
show all of my data at one time.

--

Dave Peterson

too many columns. Sounds like you should probably make that a row
field in the pivot table.

William wrote:
Hello I have a excel spreadsheet that I need to change into a pivot table.
The dates are listed in the date column daily. (1/1/01= $10 , 1/2/01= $
10,1/3/01= 10) I want the pivot table to group the dates and give me the sums
of a specific month. Jan 01 = $30. The reason I need to do this is because
the pivot table is also stating that I have too many columns and it wont
show all of my data at one time.