Why aren't dates always available to group in pivot tables?

J

JLM

I download data that gives me sales number by individual day. I build a
pivot table to get total sales by day and then group the process day by month
or quarter. Sometimes this works perfectly, while other times I get the
message 'Cannot group that selection'. Has this happened to anyone else? Is
there a limit to the number of rows or columns that can be grouped?
 
C

cs02000

I played around with the grouping for a while and found that if I
deleted a couple of date entries (to cause the error) I was unable to
regroup the date field after restoring the deleted dates.
 
K

Ken Wright

You cannot have any blanks, text, or non date entries in a date field if you
want to be able to group the dates.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
D

Debra Dalgleish

After restoring the dates in the source data, remove the date field from
the pivot table
Refresh the pivot table
Add the date field to the pivot table, and you should be able to group
the dates.
 
Top