Group Pivot data by week
 

I am trying to automaticallly group a pivot table by week. When I go into
group... from the pivot table field, I get a dialog box that says I can not
group. I can manually select these dates and group them, but new dates are
added to my data source daily, and I would like this report to automatically
group them. What am I doing wrong?

Group Pivot data by week
 

That error can occur if there are blank cells or cells with text in the
date column. There are some suggestions here for fixing the problem:


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

cbrah wrote:
I am trying to automaticallly group a pivot table by week. When I go into
group... from the pivot table field, I get a dialog box that says I can not
group. I can manually select these dates and group them, but new dates are
added to my data source daily, and I would like this report to automatically
group them. What am I doing wrong?


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

Group Pivot data by week
 

Thanks Debra - I'm sure thats it.

"Debra Dalgleish" wrote:

That error can occur if there are blank cells or cells with text in the
date column. There are some suggestions here for fixing the problem:


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

cbrah wrote:
I am trying to automaticallly group a pivot table by week. When I go into
group... from the pivot table field, I get a dialog box that says I can not
group. I can manually select these dates and group them, but new dates are
added to my data source daily, and I would like this report to automatically
group them. What am I doing wrong?


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