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
 
Ad

Advertisements

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

Top