Prev: Filtered Mode Copying and pasting as value yield as error?
Next: removing objects..!
From: evoxfan on 15 Mar 2010 10:22
In my pivot table I tried to right click the "Date" column in order to group
by month.
A message popped up "Cannot Group that Selection".
Is there another way to group by month?
Should I create another column for month in my data source?

These are my headers for data source on another worksheet in the same
workbook.
PC# DATE PAYEE DESCRIPTION CHECK AMOUNT PHASE CODE

Thanks in advance for any help.

From: evoxfan on 15 Mar 2010 11:52
I found the error.
Some of the dates were blanks or the values in the amount column were blanks.
After correcting the data, the pivot table worked fine.

"evoxfan" wrote:

> In my pivot table I tried to right click the "Date" column in order to group
> by month.
> A message popped up "Cannot Group that Selection".
> Is there another way to group by month?
> Should I create another column for month in my data source?
>
> These are my headers for data source on another worksheet in the same
> workbook.
> PC# DATE PAYEE DESCRIPTION CHECK AMOUNT PHASE CODE
>
> Thanks in advance for any help.
>
 | 
Pages: 1
Prev: Filtered Mode Copying and pasting as value yield as error?
Next: removing objects..!