Date in Pivot table question
 

I am using a pivot table to look at summary data for our cell phone usage. I
would like to make one big spreadsheet and view the entire year. The call
dates on the spreadsheet are mm/dd/yyyy. I would like to be able to put the
date on the Page box in the pivot table, but only use the month. Is there a
way to do this or do I have to create a new column in the spreadsheet and
split out the month there?

Thanks

Date in Pivot table question
 

Hi Tom

You can Group date by Month (or Year or both), but you cannot carry out
the Grouping on a Page field.
The way round it is to drag the Date to the Row Area.
Click on the Field heading and from the dropdown on the PT toolbar,
select Group and OutlineGroupMonth
Then, once grouped, drag the Date field to the Page Area

Be aware that Grouping on Dates, Excel does not like and blank cells or
cells containing non-Excel dates - it will come up with the warning
"Cannot group by that selection".

If it were me, I would highlight Year and Month when doing the grouping,
then if data does overlap years you have the choice of consolidating all
data for a given month or splitting it. Once grouped the Year field can
be dragged to other locations quite independently of the Month field

--
Regards

Roger Govier


"Tom Bradstreet" wrote in
message ...
I am using a pivot table to look at summary data for our cell phone
usage. I
would like to make one big spreadsheet and view the entire year. The
call
dates on the spreadsheet are mm/dd/yyyy. I would like to be able to
put the
date on the Page box in the pivot table, but only use the month. Is
there a
way to do this or do I have to create a new column in the spreadsheet
and
split out the month there?

Thanks

Date in Pivot table question
 

Roger - Thanks for the information...

Tom