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 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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
External Data and Pivot Tables | Jaco | Worksheet Functions | 0 | October 3rd, 2005 04:45 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Do Pivot Tables have an automatic data range expansion? | David.c.h | General Discussion | 1 | March 26th, 2005 12:55 AM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |