Pivot Tables

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.
 
G

Gbonda

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
 
D

Debra Dalgleish

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
 

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 0
Dealing with a Pivot Table (when I don't want to) 0
Incone & Expenses Statement 0
Power Pivot. Yikes. 0
grouping dates in a pivot table 1
Multiple Tables and Multiple Pivot Tables Help 0
DATE Calculations in pivot table 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0

Top