Pivot table group dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RD Wirr - 20 Jul 2006 03:16 GMT

I have a pivot table based on a medium sized set of data (5500 rows). In the
left column of the pivot table I have regular dates wich gives me almost the
same number of row in the pivot table. When I try to group the date field, I
get the error message "Cannot group that selection". I have no blanks in the
field of date. On some other similar pivot tables it work but for some reason
not this one... What causes this and how do I get past it?
Thanks in advance,
RDW

Reply to this Message

Dave Peterson - 20 Jul 2006 03:36 GMT

Do you have any text in that field?

Are you sure the range you used to build the pivottable didn't go past what you
think is the last row?

When I'm sure I did everything ok, but excel is sure I didn't, I'll rebuild the
pivottable. Sometimes that works for me.

> I have a pivot table based on a medium sized set of data (5500 rows). In the
> left column of the pivot table I have regular dates wich gives me almost the
[quoted text clipped - 4 lines]
> Thanks in advance,
> RDW

Signature

Dave Peterson

Reply to this Message

RD Wirr - 22 Jul 2006 18:16 GMT

Thanks Dave,

Sure enough it was text in the date field. Hard to find sometimes. Thanks
for the tips.

Rgds,
RD Wirr

> Do you have any text in that field?
>
[quoted text clipped - 12 lines]
> > Thanks in advance,
> > RDW

Reply to this Message

Dave Peterson - 22 Jul 2006 20:05 GMT

If it happens again, you could at least check to see how many numbers are in a
range (and dates are just numbers).

=count(a2:a9999)

And compare that with the number of cells in that range (9998 in my example).

> Thanks Dave,
>
[quoted text clipped - 24 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message