Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
grouping data in pivot tables
I am trying to group some dates in a pivot table, however when I select the
field, right click and select "group", I get an error - "Can't group that selection". I have checked that the field is formatted correctly (dates). Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
grouping data in pivot tables
Hi,
Make sure you have no blank rows in your Pivotdata range, and that you have no blank cells in your date range. The data grouping wont work in those cases. Regards Govind. Johnson748r wrote: I am trying to group some dates in a pivot table, however when I select the field, right click and select "group", I get an error - "Can't group that selection". I have checked that the field is formatted correctly (dates). Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
grouping data in pivot tables
Thanks Govind.
"Govind" wrote: Hi, Make sure you have no blank rows in your Pivotdata range, and that you have no blank cells in your date range. The data grouping wont work in those cases. Regards Govind. Johnson748r wrote: I am trying to group some dates in a pivot table, however when I select the field, right click and select "group", I get an error - "Can't group that selection". I have checked that the field is formatted correctly (dates). Any suggestions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
grouping data in pivot tables
I am getting the same error. I've reformatted the dates various ways and I
get get my spreadsheet to group by quarters. I've tried rearranging my pivot table, removed any blanks, etc. I've never had a problem like this come up before. ANy suggestions? "Johnson748r" wrote: I am trying to group some dates in a pivot table, however when I select the field, right click and select "group", I get an error - "Can't group that selection". I have checked that the field is formatted correctly (dates). Any suggestions? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
grouping data in pivot tables
If there are "Blank" elements in your pivot table, edit the source data to
eleminate them by either adding the word "Blank" or deleting. Refresh the table and then try to group again. -- TX-CPA "sbates26" wrote: I am getting the same error. I've reformatted the dates various ways and I get get my spreadsheet to group by quarters. I've tried rearranging my pivot table, removed any blanks, etc. I've never had a problem like this come up before. ANy suggestions? "Johnson748r" wrote: I am trying to group some dates in a pivot table, however when I select the field, right click and select "group", I get an error - "Can't group that selection". I have checked that the field is formatted correctly (dates). Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
ARRANGING DATA IN PIVOT TABLES | Excel Worksheet Functions | |||
need pivot tables to look more like crosstabs with repeating data. | Excel Discussion (Misc queries) | |||
show items with no data option in pivot tables | Excel Discussion (Misc queries) | |||
Do Pivot Tables have an automatic data range expansion? | Excel Discussion (Misc queries) |