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
|