Pivot Tables and Formatting

  • Thread starter Thread starter Gary Mayo
  • Start date Start date
G

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
 
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
 
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.
 
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
 
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
:-).
 
Back
Top