Home > Pivot Table > Pivot Table Cannot Group Date

Pivot Table Cannot Group Date

Contents

To start viewing messages, select the forum that you want to visit from the selection below. I do not have missing, blank, or error values in the source data for the field "delivered." With all that said, when I right click on a date value in the US Election results 2016: What went wrong with prediction models? I'm not sure why this happens. this contact form

In Revelation 19:16, of which kings is Jesus king? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 10th, 2004,06:19 PM #2 Juan Pablo González MrExcel MVP Join Date Feb 2002 Location Bogota, Colombia Posts 11,959 All contents Copyright 1998-2016 by MrExcel Consulting. This column contains only dates. http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/cannot-group-data-for-date-fields-in-a-pivot-table/fe380d63-446d-e011-8dfc-68b599b31bf5

Excel Pivot Table Group Field Grayed Out

Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows asked 1 year ago viewed 1353 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 Should I report it?

However, the date field I was trying to group was located in the Page Field section (top left corner filters). Email * Name * 1 Answer Vote Up 0 Vote Down Public Jared ⋅ August 18, 2014 at 4:02pm You can add the following line in your dex.ini to remove all During this upgrade there may be some intermittent down time preventing access to the forum or certain features. Pivot Table Not Grouping Dates Are there quick ways to implement the solutions and data-checking such as checking for blank cells in a 13,000 row database?

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. Cannot Group That Selection Excel 2013 Pivot Table Results 1 to 4 of 4 Thread: [Solved] Pivot Tables : “Cannot Group That Selection” error Thread Tools Show Printable Version Search Thread Advanced Search February 11th, 2004 #1 steveski Then base the pivot table on this new column and uncheck the bogus date field. http://www.ozgrid.com/forum/showthread.php?t=18319 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

Cancel current community blog chat Super User Meta Super User your communities Sign up or log in to customize your list. Pivot Table Grouping Not Working Why were pre-election polls and forecast models so wrong about Donald Trump? Grouping pivot tables by text is a similar feature that allows pivot tables to be grouped by text values. How to reply?

Cannot Group That Selection Excel 2013 Pivot Table

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 We apologize in advance for any inconvenience this may cause. Excel Pivot Table Group Field Grayed Out And "Group Field" in the ribbon is greyed out. Cannot Group That Selection Excel 2007 Pivot Table FREE Excel Help Here!

asked 4 years ago viewed 7428 times active 4 years ago Related 1Excel pivot table group all months by year2Dates not recognized as dates in pivot table pulling directly from SQL weblink Excel understands this as date when formatted as a date. LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Confirmed in both the pivot table and the source data. –ChrisG May 22 '15 at 14:10 Any chance you could share the workbook of a file that shows that Excel Cannot Group Columns

Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 18th, 2011,01:02 PM #8 kruseos New Member Join Date Dec 2011 Posts 1 Re: Pivot Table: “Cannot Group I clicked on the “Start Date” In the Column Filed area and selected Grouping by Month & Year. It looks like it is in some strange format – but I can not find in which one or what's wrong. http://amigasuperbit.com/pivot-table/pivot-table-date-group-cannot-group-that-selection.html Can a president win the electoral college and lose the popular vote Do humans have an ethical obligation to prevent animal on animal violence?

Non-Repetitive Quine Can negative numbers be called large? Cannot Group That Selection Pivot Table 2013 The system returned: (22) Invalid argument The remote host or network may be down. This will bring in the date as a serialized number.

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).

Join your peers and be in the know Get our must-read email featuring quality content and insights from the finest writers direct to your inbox. 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 Is Area of a circle always irrational How can an advanced (circa 7000 AD) spacefaring human civilization be prevented from entering its own solar system? Group Dates In Pivot Table Excel 2013 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 &

Thanks. Regards Weasel Kind Regards Pesky Weasel "I have a plan so cunning, you could put a tail on it and call it a Weasel." EB Eagles may soar, but Weasels don't 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 his comment is here The other common reason for not being able to group data is that you have both text and numeric data in the same field.

Not the answer you're looking for? The whole column should be converted to numbers. Pivot tables won't allow you to group dates if there are any invalid dates within the data source. 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

Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 10th, 2004,06:28 PM #4 Juan Pablo González MrExcel MVP Join Date Feb 2002 Location Bogota, Colombia Posts 11,959 Cannot Group that SelectionThe first problem "Cannot Group that Selection" is normally caused by one of two things. Check for faulty dates by sorting the database into date order. The first, and most likely cause, is due to the fact that your Pivot Table data range includes blank cells within the field in which you are trying to group.