Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table and grouping
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table and grouping
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table and grouping
On Jul 23, 6:45 pm, "Roger Govier" wrote:
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 "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.- Hide quoted text - - 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table and grouping
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 On Jul 25, 1:00 am, cricket7 wrote: On Jul 23, 6:45 pm, "Roger Govier" wrote: 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 togroupcontains text (check that yourdatesare all validExceldates, 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 toPivotTables Mike Alexanderhttp://www.datapigtechnologies.com/ExcelMain.htm Ed Ferrerohttp://www.edferrero.com/ExcelTutorials/PivotTableTutorial2003/tabid/... -- Regards Roger Govier "cricket7" wrote in message oups.com... Last week I was able to get grouping to work in mypivottable 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 " cannotgroupthat 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 thepivot tables and reports. Hopefully by practicing. THanks.- Hide quoted text - - Show quoted text - Thanks. I went back to my data source and changed all blanks todatesand made sure all the date formats were the same and nothing was text. I went back to thepivottable and refreshed the table. I moved the field I was trying togroupto the row fields. Then I tried togroupagain. I got the same error message. What can I try now?- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table and grouping
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. -- Regards Roger Govier "cricket7" wrote in message oups.com... On Jul 23, 6:45 pm, "Roger Govier" wrote: 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 "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.- Hide quoted text - - 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
Pivot Table or Grouping Help | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Worksheet Functions | |||
Grouping in Pivot Table | Excel Worksheet Functions | |||
Pivot Table Grouping | Excel Discussion (Misc queries) |