| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Problem in Pivot
I am trying to group dates so they sum by month. I keep getting a pop-up
window that says 'Cannot Group that selection'. I have tried different data sets but keep getting the same result. What am I doing wrong? Thank you. Adam |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Grouping Problem in Pivot
If you have text or empty cells in that field, you won't be able to group that
field. ADub wrote: I am trying to group dates so they sum by month. I keep getting a pop-up window that says 'Cannot Group that selection'. I have tried different data sets but keep getting the same result. What am I doing wrong? Thank you. Adam -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Grouping Problem in Pivot
Thank you. I looked for empty cells or text but cannot find them. Is there
a way to double check? Seems simple but I am stuck. Thanks. "Dave Peterson" wrote: If you have text or empty cells in that field, you won't be able to group that field. ADub wrote: I am trying to group dates so they sum by month. I keep getting a pop-up window that says 'Cannot Group that selection'. I have tried different data sets but keep getting the same result. What am I doing wrong? Thank you. Adam -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Grouping Problem in Pivot
There are some suggestions for fixing the problem he
http://www.contextures.com/xlPivot07.html#Problems ADub wrote: Thank you. I looked for empty cells or text but cannot find them. Is there a way to double check? Seems simple but I am stuck. Thanks. "Dave Peterson" wrote: If you have text or empty cells in that field, you won't be able to group that field. ADub wrote: I am trying to group dates so they sum by month. I keep getting a pop-up window that says 'Cannot Group that selection'. I have tried different data sets but keep getting the same result. What am I doing wrong? Thank you. Adam -- Dave Peterson -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expert Needed!!!!!!!!!! Pivot problem | Excel Discussion (Misc queries) | |||
| Pivot table from CSV data, problem with percentage of total. | Excel Worksheet Functions | |||
| Pivot Table Grouping or Calculated Field | Excel Discussion (Misc queries) | |||
| Pivot chart problem | Charts and Charting in Excel | |||
| grouping field in pivot table! | Excel Worksheet Functions | |||
Linear Mode
