| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Group by Date Excel 2007
In my pivot table I tried to right click the "Date" column in order to group
by month. A message popped up "Cannot Group that Selection". Is there another way to group by month? Should I create another column for month in my data source? These are my headers for data source on another worksheet in the same workbook. PC# DATE PAYEE DESCRIPTION CHECK AMOUNT PHASE CODE Thanks in advance for any help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Group by Date Excel 2007
I found the error.
Some of the dates were blanks or the values in the amount column were blanks. After correcting the data, the pivot table worked fine. "evoxfan" wrote: In my pivot table I tried to right click the "Date" column in order to group by month. A message popped up "Cannot Group that Selection". Is there another way to group by month? Should I create another column for month in my data source? These are my headers for data source on another worksheet in the same workbook. PC# DATE PAYEE DESCRIPTION CHECK AMOUNT PHASE CODE Thanks in advance for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table group by date question | Excel Discussion (Misc queries) | |||
| Excel 2007 Pivot Table - Group Field function is not always availa | Excel Worksheet Functions | |||
| Pivot Table date group | Excel Discussion (Misc queries) | |||
| Cannot group by date in a pivot table | Excel Worksheet Functions | |||
| How to group date in pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
