If you have formatting that overide the default alignment on that column you can check by fomatting one of the cells as a number. However, the date field I was trying to group was located in the Page Field section (top left corner filters). How do I make an alien technology feel alien? ALL purchases totaling over $150.00 gets you BOTH! this contact form
Ozgrid is Not Associated With Microsoft. My cat sat on my laptop, now the right side of my keyboard types the wrong characters How does Gandalf end up on the roof of Isengard? Then base the pivot table on this new column and uncheck the bogus date field. Also, the time in the original cell is in an unknown format.
Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search If the are Right aligned - dates, Left aligned - text. To start viewing messages, select the forum that you want to visit from the selection below.
When I select the drop down for Row Labels "Date Filters" is an option that appears. In the Pivot Table “Start Date” is a Column Field. Compare Excel | Excel Templates | DownloaderXL Pro Finance Templates & Add-In Bundle | NeuroXL Predictor | Construction Estimating Merge Excel The Easy Way | Trading Add-ins For Excel Pivot Table Grouping Not Working After reformatting the date column you should be able to group on that column.
You may have to widen your column a little, to actually see whether your data is left aligned (text) or right aligned (numbers). Cannot Group That Selection Excel 2013 Pivot Table If the are Right aligned - dates, Left aligned - text. I'm thinking of adding an additional "Start Date 2" column which grabs the date if there is one, and puts in a bogus date (e.g., 1/1/1900) if there is not one. http://www.ozgrid.com/forum/showthread.php?t=18319 Any advice for getting the pivot table to ignore the blanks?
While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. Pivot Table Not Grouping Dates Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. In the Pivot Table “Start Date” is a Column Field. How does Gandalf end up on the roof of Isengard?
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 go to this web-site 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 Excel Pivot Table Group Field Grayed Out All contents Copyright 1998-2016 by MrExcel Consulting. Cannot Group That Selection Excel 2007 Pivot Table If the blanks are due to your PT Source Data range going beyond its current data, use a Dynamic Named Range: http://www.ozgrid.com/Excel/DynamicRanges.htm You should do this anyway.
How do I "lock" my Linux box for few hours? weblink Ozgrid is Not Associated With Microsoft. Please try the request again. Advanced Excel Integration XL-Dennis corner in the Excel-world OTHER STUFF DAVE HAWLEY FOUNDATION Newsletters Competitions HAV-A-CHAT Book Suggestions & Reviews Test Area Excel Development & Consultancy EXCEL SEARCH & RESOURCES Excel Excel Cannot Group Columns
But if even just one out of 10,000 or 20,000 date fields is faulty, the Group function refuses to work. Fill Blank Cells Within a List Let's say you have a list of entries in column A and within the list you have many blank cells. option is greyed out, or that a message box pops up, saying "Cannot Group That Selection", this is usually because the data column in the original data sheet contains one or navigate here Any advice for getting the pivot table to ignore the blanks?
As a monk, can I use Deflect Missiles to protect my ally? Cannot Group That Selection Pivot Table 2013 Any faulty dates will be found in the first and last rows. 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).
Fill Blank Cells Within a List Let's say you have a list of entries in column A and within the list you have many blank cells. Grouping pivot tables by text is a similar feature that allows pivot tables to be grouped by text values. Luckily, you don't have to double-click you way down the whole list. Group Dates In Pivot Table Excel 2013 Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc.
Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Nov 15th, 2011,12:14 AM #7 gepa New Member Join Date Jan 2008 Posts 4 Re: Pivot Table: “Cannot Group I did not have any empty spaces and all of my dates were formatted properly. 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 http://amigasuperbit.com/pivot-table/pivot-table-date-group-cannot-group-that-selection.html On 1941 Dec 7, could Japan have destroyed the Panama Canal instead of Pearl Harbor in a surprise attack?
Backup copies of the file worked, but every time I went to the most recent, or copied the data from the most recent to the backup, the table messed up. Please Login or Register to read the full article The full article is available to registered AccountingWEB.co.uk members only. Can you tell me some possible causes of this error? Start Date is also used as the data field (Count of Start Date).
However, I do have blanks in the column, and I've been told that will produce the error I'm getting. I have sorted it to confirm that it's sorting as a date. Are there quick ways to implement the solutions and data-checking such as checking for blank cells in a 13,000 row database? Ballpark salary equivalent today of "healthcare benefits" in the US?
If the blanks are in-between other dates you will need to fill them. 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). 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 Now push Equals (=) then the Up arrow and finally holding down the Ctrl key push Enter.