Hi,
I've created a pivot table with dates in the column that i'd now like to group together to show monthly or weekly data instead of the individual days.
Normally, i simply right click and select Group. However i am being told that i cannot group this selection.
The data is formatted in date format prior to being pivoted so this shouldn't be a problem. Can anyone shed any light on why this is happening and how i can fix it?
Many thanks for your time
Ian
Bookmarks