Grouping dates in a pivot table

  • Thread starter Thread starter Fred Smith
  • Start date Start date
F

Fred Smith

I have a table of bond maturity dates which I want to group by year.

When I create the pivot table, then try to Group the maturity date column, I get
the message "Cannot group that selection"

This normally happens if I have a non-date in the column of data, but I have
checked the data very carefully and am sure every cell is a valid date.

Is there anything else I can look for? If it means anything, the dates extend
out to 2053.
 
Any chance you included too many rows (and have an empty cell in that field)?

If you delete the existing pivottable and recreate it, does it work ok?
 
Your reply pointed me in the right direction.

My data table actually contains entries for bonds, stocks, etc. I was using a
Page variable to select only the bonds. When I sorted the data by class, then
specified a pivot table range of only the bond entries, then it let me group the
maturity dates.

Now I just have to program this in VBA.

Thanks for your help.
 
Back
Top