Pivot Table

B

Box666

In the base data of a pivot table i have a column of dates (from 1st
June to 31st Dec 2007) in the format "29/12/2007". In the pivot table
i would like it to summarise the data by month. ie "Dec 2007".
So in the base data i added another column Z (original dates in col B)
and input "=B2" and then formatted the cell as "mmmyyyy". Whilst this
then "looks" ok on the base sheet when you add it to the pivot table
it reverts back to its original format. I did then try and format it
in the pivot table and whilst i can get it to show as eg"Dec2007" it
still retains all of the original rows and will not summarise.

Any suggestions please.

Bob
 
J

Jim Thomlinson

Right click on the Date field and select Group. Assuming that all of the data
is valid dates you will be given the option to group by year, month, quarter,
.... This will automatically give you your summarization...
 

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 converts to text 2
date filter in a pivot table 1
Excel 2003 Pivot Formatting 2
Pivot Table - NUMBER FORMAT option does not appear in field settin 3
Pivot table wizards 2
Pivot Table - Changes 5
New To Pivot Tables 4
Pivot Table and adding a % column, that is not in original data 3

Top