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/ExcelTutori...9/Default.aspx
--
Regards
Roger Govier



"cricket7" wrote in message
ups.com...
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.