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
|
|||
|
|||
cannot group that selection
I'm following the FAQ for taking a list of dates produced by my piviot table
and trying to group them by week. When I select the field name, right click and select grouping, I get "cannot group by the selection". My data source for this field in the table is all dates (other than the header). -- Thanks! |
#2
|
|||
|
|||
cannot group that selection
Maybe you've included some blank rows at the end of the source data, or
some of the dates are entered as text. There are suggestions for fixing the problem he http://www.contextures.com/xlPivot07.html#Problems DoubleACL wrote: I'm following the FAQ for taking a list of dates produced by my piviot table and trying to group them by week. When I select the field name, right click and select grouping, I get "cannot group by the selection". My data source for this field in the table is all dates (other than the header). -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
cannot group that selection
Got it. My data has a lot of blanks, and if I delete the rows containing the
blank fields, I can build a grouping selection. Normally, I can remove the blanks from being reported in my Pivot Table by deselecting blanks in the field options box. However for grouping, I find that merely deselecting blanks does not then allow grouping; the data itself cannot have blanks, which is going to be a pain. I'm going to have to create some temporary tables to accomplish the grouped report, unless you know of any other solution. -- Thanks! "Debra Dalgleish" wrote: Maybe you've included some blank rows at the end of the source data, or some of the dates are entered as text. There are suggestions for fixing the problem he http://www.contextures.com/xlPivot07.html#Problems DoubleACL wrote: I'm following the FAQ for taking a list of dates produced by my piviot table and trying to group them by week. When I select the field name, right click and select grouping, I get "cannot group by the selection". My data source for this field in the table is all dates (other than the header). -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
cannot group that selection
I often get a similar issue when using a data dump form our pricing system,
but the blanks are usually associated with zero value items, so what i do is select the entire range of dates, do edit / Go to / Special / Blanks and then enter in the lowest date (can be any date) that exists in my data and use CTRL+ENTER to enter it. This puts it in every blank cell, and then all you need to do is refresh the PT. Because they are zero value items, it doesn't matter that these now get included in the grouping. Don't know if it will work for you, depends on your data, but worth mentioning. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "DoubleACL" wrote in message ... Got it. My data has a lot of blanks, and if I delete the rows containing the blank fields, I can build a grouping selection. Normally, I can remove the blanks from being reported in my Pivot Table by deselecting blanks in the field options box. However for grouping, I find that merely deselecting blanks does not then allow grouping; the data itself cannot have blanks, which is going to be a pain. I'm going to have to create some temporary tables to accomplish the grouped report, unless you know of any other solution. -- Thanks! "Debra Dalgleish" wrote: Maybe you've included some blank rows at the end of the source data, or some of the dates are entered as text. There are suggestions for fixing the problem he http://www.contextures.com/xlPivot07.html#Problems DoubleACL wrote: I'm following the FAQ for taking a list of dates produced by my piviot table and trying to group them by week. When I select the field name, right click and select grouping, I get "cannot group by the selection". My data source for this field in the table is all dates (other than the header). -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Option Group Label Issue | Jay | Using Forms | 8 | November 8th, 2005 01:51 PM |
How do i hide a group footer if it's the only group? | Darin | Setting Up & Running Reports | 7 | August 30th, 2005 02:45 PM |
Option Group Problem | Emma | Using Forms | 13 | April 23rd, 2005 06:34 PM |
Group By | Running & Setting Up Queries | 3 | August 5th, 2004 10:37 PM | |
making option groups visible/invisible based on another option group selection | Emma | Using Forms | 3 | June 24th, 2004 05:29 AM |