Pivot Tables

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

I am working with date fields in a pivot table. I would
likd to cluster the dates by month but the actual dates in
the pivot data are multiple dates within each month. Any
ideas on how to change the data so it will combine totals
by month only?

Thanks.
 
You have to break the month out in the source data. I am assuming you
dates look like this 04-1-2004. Insert a column in the source data.
(If you put it at the end then you will have to expand the range of th
pivot table). Use the month fuction.

A B
04-1-2004 =month(A1)

This will pull the month number only. Go to the pivot table an
refresh data. The new column should appear. This should have only th
month numbers.

Gre
 
Add the date field to the row area
Right-click on the Date field button
Choose Group and Show Detail>Group
Choose to Group by Years and Months
Click OK
 
Back
Top