[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!

[Debra Dalgleish]

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