Grouping dates in a pivot table
 

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.

--
Regards,
Fred

Grouping dates in a pivot table
 

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?

Fred Smith wrote:

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.

--
Regards,
Fred

--

Dave Peterson

Grouping dates in a pivot table
 

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.

--
Regards,
Fred


"Dave Peterson" wrote in message
...
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?

Fred Smith wrote:

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.

--
Regards,
Fred

--

Dave Peterson