Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
grouping date in pivot table
I have a pivot table containing dates, products and amount. I have right
clicked the date field to group the dates bi-weekly since the only dates in the column are 1/15/2009,1/31/2009,2/15/2009,2/28/2009..etc YET i receive an error that states "cannot group that selection".....i ensured it is in date format...what else could cause this??? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
grouping date in pivot table
Hi
If there are any empty cells in the range of dates, then Excel will not group them. Perhaps you have defined a range for your PT which included blank rows to allow for future data input. That would cause it not to group. Instead, define a dynamic range InsertNameDefine Name myData Refers to =$A$1:INDEX($1:$65536,COUNTA($A:$A),COUNTA($1:$1)) Right click on the PTPT WizardBackSource = myDataFinish Drag your date field off the PTRefreshDrag your date field back again and try Grouping. If that doesn't work for you, post back -- Regards Roger Govier "acss" wrote in message ... I have a pivot table containing dates, products and amount. I have right clicked the date field to group the dates bi-weekly since the only dates in the column are 1/15/2009,1/31/2009,2/15/2009,2/28/2009..etc YET i receive an error that states "cannot group that selection".....i ensured it is in date format...what else could cause this??? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
grouping date in pivot table
Besides Roger's suggestions, any cells that are text as opposed to dates
will also cause this error. Make sure the data is clean, the range is correct, refresh, save and close and reopen and you should be able to get past it. Regards Ken.................... "acss" wrote in message ... I have a pivot table containing dates, products and amount. I have right clicked the date field to group the dates bi-weekly since the only dates in the column are 1/15/2009,1/31/2009,2/15/2009,2/28/2009..etc YET i receive an error that states "cannot group that selection".....i ensured it is in date format...what else could cause this??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table W/E Date Grouping using external .CSV | Excel Worksheet Functions | |||
Grouping Date Fields in Pivot Table | Excel Discussion (Misc queries) | |||
Grouping Date Data in a Pivot Table | Excel Worksheet Functions | |||
Grouping By Date in Pivot Table | Excel Worksheet Functions | |||
Pivot table-date grouping | Excel Discussion (Misc queries) |