Pivot Table Help - Data Manipulation

  • Thread starter Thread starter sgore
  • Start date Start date
S

sgore

I have a column for the actual date and a column for a grade. I hav
created a pivot table to total up information in regards to this data.

I need to sum up the amounts by the month not the individual day.
However I need to keep the individual date as mm/dd/yy.

Is there a way that I can manipulate the pivot table to sum up based o
the month only?


Date
1/2/04
1/3/04
...
5/6/04

Grade
2
1
...
5

The pivot table works ok however I really only need to sum up th
totals for each month not for each particular day. Is there a way tha
I can use the same day column but only calculate the totals based o
month within the pivot table?


I can email an example spreadsheet if you would like to see what I a
trying to do. I tried to upload it but could not.

Any help would be most appreciated
 
Hi
try grouping the data item by months (you find this option in the pivot
menu)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table data 2
Calculating total amount in a Pivot Table 1
Inputing data into Pivot Table 2
Excel 2003 Pivot Table - Grand Total 4
Group by month in a Pivot table 2
Pivot table problem 4
Multiple Pivot Tables based on the same data 3
How do I convert dates to months in Pivot Tables? 1

Back
Top