G
Guest
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?
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?