Pivot Table
 

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!

Pivot Table
 

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

Buyone wrote:
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!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html