I ahev a pivot table which contains due date of payment, actual date of
payment and the value of the payments. All the dates are in teh format
dd/mm/yyyy. I'm trying to get down to a basic month for each payment, so I
get a total received for January and a breakdown that shows how much of
Januray's receipts is applicable to January, february and so on. At teh
moment the pivot table is giving me a row for each date.
According to the help file, I should be able to group them together by
month, but when I select the data I want to group, I have the option to Group
but not to select by Month or anything else.
Anyone any ideas where I'm going wrong?