I have a data entry sheet with a column titled “Start Date”. This column contains only dates.
I have a Pivot Table based on the data entry sheet. In the Pivot Table “Start Date” is a Column Field. Start Date is also used as the data field (Count of Start Date).
I clicked on the “Start Date” In the Column Filed area and selected Grouping by Month & Year.
While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. Then I brought in a column of dates from the ‘real’ data entry sheet, and now the grouping is not functional (“Cannot Group That Selection” error).
Can you tell me some possible causes of this error?
Thanks.
I have a Pivot Table based on the data entry sheet. In the Pivot Table “Start Date” is a Column Field. Start Date is also used as the data field (Count of Start Date).
I clicked on the “Start Date” In the Column Filed area and selected Grouping by Month & Year.
While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. Then I brought in a column of dates from the ‘real’ data entry sheet, and now the grouping is not functional (“Cannot Group That Selection” error).
Can you tell me some possible causes of this error?
Thanks.