Pivot Tables and Formatting

[Gary Mayo]

I have a list of dates but I only want the pivot table to
group them by month, not by day.

Ex:

Month
11/1/03
11/3/03
11/4/03
12/2/03
12/4/03

I want the pivot table to show 3 for Nov, 03 and 2 for Dec

 

[Jason Morin]

Add a column to your data and use:

=MONTH(A1)

This will return 1 for Jan., 2 for Feb, 3 for Mar., etc.
Then re-run your pivot table and use this column rather
than the date column.

HTH
Jason
Atlanta, GA

 

[Ken Wright]

Put them into your table by day initially and then right click on the dates in
the Pivot Table and select Group - Then select both Months and Years and hit OK.

 

[Clyde Lomax]

Ken,

Thanks for this. You would not believe how I have been doing it. Also
noted "the pivot table report will not fit on the sheet" message comes up.
I selected the show as much as possible then do the grouping and refresh and
it now fits.

Thanks lomax

 

[Ken Wright]

I didn't realise it was there either till I read a post of Debra Dalgelish's -
then promptly kicked myself from here to Sunday for not having picked up on it
before. I couldn't believe how much time it saved me - Thanks again Debra
.