Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Register To Reply 09-20-2012,12:35 PM #6 kbaruin View Profile View Forum Posts Registered User Join Date 09-11-2012 Location UK MS-Off Ver Excel 2003 Posts 81 Re: Pivot Table Error: 'CANNOT GROUP Build me a brick wall! have a peek here
This worked for me! More About Us... IN operator must be used with an iterable expression Inequality caused by float inaccuracy Why do languages require parenthesis around expressions when used with "if" and "while"? It's aligned on the left side of the cell and if I double click on the cell, the time will jump to the right side.
So it has none of the above problems. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Here is the set if data I have. Pivot Table Grouping Not Working I am getting an error which reads 'CANNOT GROUP THAT SELECTION' when trying to use the 'Group' feature on a field in a pivot table.
Regards Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 3rd, 2013,11:33 AM #10 PaulR42 New Member Join Date Dec 2013 Posts 1 Re: Pivot Table: “Cannot How were Lisps usually implemented on architectures that has no stack or very small stacks? Thanks Paul Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Page 1 of 2 12 Last Jump to page: « Previous Thread | Next Thread » Like http://www.mrexcel.com/forum/excel-questions/74642-pivot-table-%93cannot-group-selection%94-error.html You'll be able to ask any tech support questions, or chat with the community and help others.
And "Group Field" in the ribbon is greyed out. Pivot Table Not Grouping Dates nivrip posted Nov 7, 2016 at 3:35 PM Highlight date ranges DĂ©cioC posted Nov 7, 2016 at 10:42 AM WCG Stats Monday 07 November 2016 WCG Stats posted Nov 7, 2016 Several functions may not work. I did not have any empty spaces and all of my dates were formatted properly.
The whole column should be converted to numbers. http://www.excelfunctions.net/group-pivot-table.html Don't post a question in the thread of another member -- start your own thread. Excel Pivot Table Group Field Grayed Out Guest, Aug 18, 2007 #1 Advertisements Guest Guest If Excel can recognize the values as dates, you'll get the grouping optons. Cannot Group That Selection Excel 2007 Pivot Table I've refreshed the pivot table, I've restarted Excel, but no luck.
For the past 3 months a pivot table that generates a report has been screwing up in an automated spreadsheet. http://kelcours.com/pivot-table/excel-pivot-table-cannot-group-that-selection.html One more step Please complete the security check to access www.ozgrid.com Why do I have to complete a CAPTCHA? Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013. When I click "Group Selection" on my invoice dates, I just get the message "Cannot group that selection". Excel Cannot Group Columns
After reformatting the date column you should be able to group on that column. I took out > > > > all blanks. TJ, Jan 15, 2010 #5 Debra Dalgleish Guest Check your pivot table source data range, and make sure that you haven't included any blank rows at the end. Check This Out THanks Originally Posted by Cutter Hello kbaruin, and welcome to the forum.
Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. Cannot Group That Selection Pivot Table 2013 Does f:x mean the same thing as f(x)? What are Fluffy Blocks?
Not sure what to do > next. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com Debra Dalgleish, Jan 24, 2010 #10 Advertisements Show Ignored Content Want to reply to this thread In Doctor Strange what was the title of the book Stan Lee was reading in his cameo? Example of dates: 01/05/2009 08/05/2009 08/05/2009 08/05/2009 08/05/2009 08/05/2009 15/06/2009 Any help? "Ron Coderre" wrote: > I'm glad you figured it out......and thanks for the feedback. > > > *********** > Group Dates In Pivot Table Excel 2013 Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel General [SOLVED] Pivot Table Error: 'CANNOT GROUP THAT SELECTION' To get
Completing the CAPTCHA proves you are a human and gives you temporary access to the web property. Is the result of the general election final on 8th of Nov, 2016? Though its im too late ,,,,,,Hope this would work ....... http://kelcours.com/pivot-table/excel-2010-pivot-table-cannot-group-that-selection-date.html Here is some of my data: Thanks, Natalie Jensen Back to top Report #2 Jonathan Jonathan Forums Administrator Administrators 758 posts Posted 30 September 2013 - 04:20 PM Hi Natalie,
Did a thief think he could conceal his identity from security cameras by putting lemon juice on his face? It takes just 2 minutes to sign up (and it's free!). Doug Muegge wrote: > Thank you for the information - I have tried clearing all blanks and > converting dates based on your guidance. Does my electronic parking brake remain engaged if I disconnect the battery?
One more step Please complete the security check to access www.ozgrid.com Why do I have to complete a CAPTCHA? All contents Copyright 1998-2016 by MrExcel Consulting. Can anyone shed light on what the problem might be? Back to top Report Back to Pivot Tables Also tagged with one or more of these keywords: pivot table, cannot group that selection Free Excel consultancy for ExcelCentral.com members → Pivot
Attached is a screen print where I show a small sample data set and the pivot table that I created from that data set. I have checked for blank rows as suggested in this thread. What can I do to prevent this in the future? Perhaps we'll spot an issue. > > > *********** > Regards, > Ron > > XL2003, WinXP > > > "Marion" wrote: > > > I am working in a pivot
© Copyright 2017 kelcours.com. All rights reserved.