I am trying to design a pivot table with data that I have downloaded from another source.

I have a full date in the date field (eg. 12/10/04) and in my pivot table I would like the dates consolidated by month (eg. 12/04). Right now I have a seperate sort for each date, not consolidated by month.

Can anyone help.

thank you