What happened to FN-1824? Excel Video Tutorials / Excel Dashboards Reports February 11th, 2004 #4 Dave Hawley View Profile View Forum Posts Visit Homepage Administrator Join Date 24th January 2003 Location Australia Posts 31,969 Hi However, I do have blanks in the column, and I've been told that will produce the error I'm getting. I've had the same experience in the past, come to think of it. –nutsch Oct 9 '12 at 16:06 add a comment| Your Answer draft saved draft discarded Sign up have a peek here
In the Pivot Table “Start Date” is a Column Field. Will not even give me the option to choose month, year,etc. I have a field called "delivered" formatted as date and I'm 99% confident it's actually a date. =TYPE confirmed it as a number, used Datevalue and posted over the source to Expression evaluates numerically inside of Plot but not otherwise Product of all divisors=cube of number. http://www.ozgrid.com/Excel/grouping-pivot-tables.htm
Keep geeting a > "cannot group that selection" error when I try to group dates. If the are Right aligned - dates, Left aligned - text. The ages range from 5 to 16 years.If you want to group the ages into the age ranges 5-8 years, 9-12 years and 13-16 years, you can this as follows:Right click
Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. Do humans have an ethical obligation to prevent animal on animal violence? More About Us... Pivot Table Grouping Not Working This column contains only dates.
Advanced Search Forum HELP FORUMS Excel General [Solved] Pivot Tables : “Cannot Group That Selection” error Excel Training / Excel Dashboards Reports IMPORTANT INFORMATION The OzGrid Free Excel & VBA Help Cannot Group That Selection Excel 2013 Pivot Table If you fix your data so that there are no invalid dates, the error should disappear. I have checked > > for blank rows as suggested in this thread. my response What would be the consequences of a world that has only one dominant species of non-oceanic animal life?
Member Login Remember Me Forgot your password? After reformatting the date column you should be able to group on that column. Excel Pivot Table Group Field Grayed Out asked 1 year ago viewed 1347 times active 1 year ago Upcoming Events 2016 Community Moderator Election ends Nov 22 Related 3Add totals line to pivot chart in Excel 20104Excel VBA Cannot Group That Selection Excel 2007 Pivot Table Will not even give me the option to choose month, year,etc.
Would we find alien music meaningful? http://kelcours.com/pivot-table/excel-pivot-table-cannot-group-that-selection.html Then I brought in a column of dates from the ‘real’ data entry sheet, and now the grouping is not functional (“Cannot Group That Selection” error). Excel Video Tutorials / Excel Dashboards Reports February 11th, 2004 #2 Pesky Weasel View Profile View Forum Posts OZMVP Join Date 7th February 2003 Location Kewarra Beach, Cairns - TNQ Posts When I click "Group Selection" on my invoice dates, I just get the message "Cannot group that selection". Excel Cannot Group Columns
Templates and Calculators The Way of the Weasel Download Ivan & Colo's HTML Maker Here 101 Excel Hacks - Great New Book Huge Savings on Excel Training February 11th, 2004 #3 Cannot Group That Selection Pivot Table 2013 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 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,
Obviously you would do this so when you add more information to your table it would automatically be included in your Pivot Table the moment you refresh it. However, the date field I was trying to group was located in the Page Field section (top left corner filters). OzGrid is in no way associated with Microsoft Some of our more popular products are below...Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Group Dates In Pivot Table Excel 2013 stdarg and printf() in C How were Lisps usually implemented on architectures that has no stack or very small stacks?
Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Mar 5th, 2004,01:46 AM #6 jillian728 Board Regular Join Date Jun 2003 Location San Diego Posts 243 Re: Pivot Are there quick ways to implement the solutions and data-checking such as checking for blank cells in a 13,000 row database? The other common reason for not being able to group data is that you have both text and numeric data in the same field. http://kelcours.com/pivot-table/excel-2010-pivot-table-cannot-group-that-selection-date.html This is shown in the following examples.Example 1: Group a Pivot Table by DateImagine you have created the pivot table on the leftshown above, which shows sales figures for each date
Empty lines or not? If you have formatting that overide the default alignment on that column you can check by fomatting one of the cells as a number. Guest, Aug 18, 2007 #4 TJ Guest Hi, I'm having the same error :-( I have tried the things suggestion in this trail but still am getting no where. Advertisements Latest Threads NES Classic Edition reviewed Becky posted Nov 8, 2016 at 4:59 PM Unable to publish Calendar in Outlook 2007 Anoop Soman posted Nov 8, 2016 at 8:37 AM
Help? :( excel excel-2010 pivot-table share|improve this question asked May 21 '15 at 17:39 ChrisG 368415 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Looks Guest, Jun 23, 2005, in forum: Microsoft Excel Misc Replies: 1 Views: 2,961 Dave Peterson Jun 23, 2005 "Cannot Group That Selection" in a Pivot Table. Stay logged in Welcome to PC Review! Not sure what to do next. -- Doug M "Debra Dalgleish" wrote: > There are a few other suggestions for fixing grouping problems here: > > http://www.contextures.com/xlPivot07.html > > > Doug
Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not Product catalog My cat sat down on my laptop, now the right side of my keyboard types the wrong characters What do you call a relay that self-opens on power loss?
© Copyright 2017 kelcours.com. All rights reserved.