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
Bookmarks