grouping data in pivot tables

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

Guest

I am trying to group some dates in a pivot table, however when I select the
field, right click and select "group", I get an error - "Can't group that
selection". I have checked that the field is formatted correctly (dates). Any
suggestions?
 
Hi,

Make sure you have no blank rows in your Pivotdata range, and that you
have no blank cells in your date range. The data grouping wont work in
those cases.

Regards

Govind.
 
Thanks Govind.

Govind said:
Hi,

Make sure you have no blank rows in your Pivotdata range, and that you
have no blank cells in your date range. The data grouping wont work in
those cases.

Regards

Govind.
Click to expand...
 
I am getting the same error. I've reformatted the dates various ways and I
get get my spreadsheet to group by quarters. I've tried rearranging my pivot
table, removed any blanks, etc. I've never had a problem like this come up
before. ANy suggestions?
 
If there are "Blank" elements in your pivot table, edit the source data to
eleminate them by either adding the word "Blank" or deleting. Refresh the
table and then try to group again.
 
Back
Top