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.