Pivot Table

  • Thread starter Thread starter Buyone
  • Start date Start date
B

Buyone

Greetings,

Quick question. I have a list of data that has dates fromatted in the normal
way, dd/mm/yyyy. I've created a dummy column to give me just mm.

Problem is when i put the info into a pivot table all the data is returned
as dd/mm/yyyy when I need the data to be grouped by month.

Thanks for your help!
 
You should be able to group the date field by months in the pivot table,
without needing a separate field.
In the pivot table, right-click on the date field, then click on Group
and Show Detail> Group
In the Grouping dialog box, click on Month, and click OK
 
Back
Top