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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 :-)
------------------------------­------------------------------­----------------
 
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.
 
Back
Top