pivot table and grouping

[cricket7]

Last week I was able to get grouping to work in my pivot table and
made 2 reports. One for April and one for May. This week I am trying
to make one for JUne and one for July but I keep getting the error
message " cannot group that selection". I cannot figure out what I am
doing wrong. I have moved the date/time field to different places. I
have tried using just a date field. But nothing works.

Is there a resource online that I can learn more about using the pivot
tables and reports. Hopefully by practicing.

THanks.

 

[Roger Govier]

Hi

You will get that message if
1 You try to do the Grouping on a Page field (move it to a Row field, do the
grouping and move back)
2 If any cell within the range you are trying to group contains text (check
that your dates are all valid Excel dates, not text representations)
3 If there are any blank cells within the range (use dynamic ranges to
ensure you are not picking up blank rows)

For further help on PT's go to Debra Dalgleish's site
http://www.contextures.com/tiptech.html
scroll down to Pivot Tables

Mike Alexander
http://www.datapigtechnologies.com/ExcelMain.htm

Ed Ferrero
http://www.edferrero.com/ExcelTutorials/PivotTableTutorial2003/tabid/89/Default.aspx

 

[cricket7]

Hi

You will get that message if
1 You try to do the Grouping on a Page field (move it to a Row field, do the
grouping and move back)
2 If any cell within the range you are trying to group contains text (check
that your dates are all valid Excel dates, not text representations)
3 If there are any blank cells within the range (use dynamic ranges to
ensure you are not picking up blank rows)

For further help on PT's go to Debra Dalgleish's sitehttp://www.contextures.com/tiptech.html
scroll down to Pivot Tables

Mike Alexanderhttp://www.datapigtechnologies.com/ExcelMain.htm

Ed Ferrerohttp://www.edferrero.com/ExcelTutorials/PivotTableTutorial2003/tabid/...
--
Regards
Roger Govier








- Show quoted text -

Thanks.
I went back to my data source and changed all blanks to dates and made
sure all the date formats were the same and nothing was text. I went
back to the pivot table and refreshed the table. I moved the field I
was trying to group to the row fields. Then I tried to group again.
I got the same error message. What can I try now?

 

[Davey.Findlay]

I had the same problem.

When I added more rows to the data range of a pivot table the grouping
by date was reset.
When I tried to regroup the data I got the error "Cannot Group The
Selection"

The only answer I could come up with was to reselect the data range
for the pivot and create a new pivot table


Regards

 

[Roger Govier]

Hi

I'm sorry I missed your response until today.
If you are still having problems, mail me a copy of the workbook and I will
see if I can see what is wrong.
To mail direct send to

roger at technology4u dot co dot uk
Do the obvious with dot and at.