If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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??? |
Thread Tools | |
Display Modes | |
|
|