More Pivot Table Grouping problem

J

Jack Jones

I have read the answer to the Pivot Table Grouping issue sent in by Hrider
about a year ago. I have the same problem but the solution doesn't seem to
apply. Still when I try to group the datesI get an error "Cannot group this
selection".

I have a two column list with column one being calendar dates sorted oldest
to newest. The second column is values associated with each date. I have
made certain that the dates are not text but actual date values by selecting
the column and Formatting cells as Number/Date/Jan-01-2001. I think that
should make sure the values are dates. What else can I try? I am using Excel
2003.

TIA.

Paul Thompson
 
D

Debra Dalgleish

Check the pivot table source range, to ensure that there are no blank
cells in the date column, or cells with a text entry, and no blank rows
have been included at the end of the range.

If that's not the problem, check for a previous grouping of the field,
as described here:

http://www.contextures.com/xlPivot07.html#Problems
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the "group and show detail" in a pivot table 3
How to a Time planning into pivot table . 1
Stupid Pivot Table question - put grouped dates into single column 3
Conditional formatting on pivottable 4
Pivot table grouping 4
Pivot Table: “Cannot Group That Selection” error 1
How to get two different grouped pivot tables from the same datatable? 6
Add the same field twice to a pivot table but filter one of them? 2

Top