Cannot group by date in a pivot table
 

I get an message saying I cannot group on that selection.

Cannot group by date in a pivot table
 

The values in that field have to be all numeric--they can't even be
blanks/empty.

MCVCOTE wrote:

I get an message saying I cannot group on that selection.

--

Dave Peterson

Cannot group by date in a pivot table
 

The field itself is a date and each entry does have a date. I've grouped on
it before but can no longer do it. I've tried refreshing, updating the data,
and nothing seems to work. It brought in the data on a daily basis and I'm
trying to group it by month instead.

"MCVCOTE" wrote:

I get an message saying I cannot group on that selection.

Cannot group by date in a pivot table
 

There may be a left over field from a previous grouping. There are
instructions here on how to fix the problem:

http://www.contextures.com/xlPivot07.html#Problems

MCVCOTE wrote:
I get an message saying I cannot group on that selection.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html