Home > Pivot Table > Pivot Table Cannot Group

Pivot Table Cannot Group

Contents

How to reply? What do I do? 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 AccountingWEB Share this content Replies Please login or register to join the discussion. this contact form

Share this content Related content {{item['sft-title']}} Advertisement Get AccountingWEB in your inbox You might also like {{item['sft-date']}} {{item['sft-section']}} {{item['sft-title']}} Trending on AccountingWEB {{item['sft-section']}} {{item['sft-title']}} Practice Excellence Practice Excellence: Tayabali Tomlin Our Luckily, you don't have to double-click you way down the whole list. US Election results 2016: What went wrong with prediction models? All contents Copyright 1998-2016 by MrExcel Consulting. browse this site

Excel Pivot Table Group Field Grayed Out

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

Non-Repetitive Quine What is the most someone can lose the popular vote by but still win the electoral college? If you try to group a row of dates and get the message "Cannot Group that Selection", it means that one or more of your dates is faulty. The first column is time, e.g. 01:02:59 The second is a number, e.g. 5 I want to create a pivot table and then group the time to be sorted by hours Pivot Table Grouping Not Working Send payment proof to [emailprotected] 31 days after purchase date.

Instant Download and Money Back Guarantee on Most Software Microsoft Excel Training- From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS Excel Trader Package Technical Analysis in Excel With $139.00 Cannot Group That Selection Excel 2013 Pivot Table Registration is FREE and allows you to view all content, ask questions, comment and much more. And until you've converted all cells from text-looking-like-time to actual time (i.e. 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 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

Story where dome is erected freezing people in time - one person gets trapped outside Straight line equation Someone peeled an American flag sticker off of my truck. Pivot Table Not Grouping Dates Blank cells are also considered to be invalid dates, so you must make sure that there are no blanks. How do I make an alien technology feel alien? While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine.

Cannot Group That Selection Excel 2013 Pivot Table

Pivot tables won't allow you to group dates if there are any invalid dates within the data source. Basically, that didn't turn up any stray text values. Excel Pivot Table Group Field Grayed Out Pivot Table Products Pivot Table Assistant for Microsoft Excel | Pivot Table XL Stat | O2OLAP for Excel Still Need Help? Cannot Group That Selection Excel 2007 Pivot Table I went to the data and found where someone had messed up the format of one date, fixed that, and the table now works, my reports now come out properly.

For more about grouping pivot tables by dates, see Expert Skills Lesson 5-20 Group by date. weblink 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 Grouping Pivot Table Data. 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 Excel Cannot Group

Once you have corrected the faulty dates, go into the pivot table and press the Refresh Data button. Can I use that to take out what he owes me? Ballpark salary equivalent today of "healthcare benefits" in the US? navigate here This is the reason I come to this site.

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 Cannot Group That Selection Pivot Table 2013 Search Enter your keywords Login Register Tech Excel Pivot Tip 18 - Date problem: 'Cannot group that selection' 19th Jul 2006 0 ExcelZone's Five Minute Tips aim to develop your skill There are currently no replies, be the first to post a reply.

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

Also, the time in the original cell is in an unknown format. Possible XML handles in Magento 2? 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, Group Dates In Pivot Table Excel 2013 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

The whole column should be converted to numbers. This is most likely a data entry error. Check for faulty dates by sorting the database into date order. http://amigasuperbit.com/pivot-table/pivot-table-date-group-cannot-group-that-selection.html FREE Excel Help Here!

As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies. But you will have to refresh the data TWI... 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 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).

You may have to widen your column a little, to actually see whether your data is left aligned (text) or right aligned (numbers). Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. Extending the data range of your pivot table well beyond the last row in your table will not only cause grouping problems, but also force Excel to reserve excess memory for Mimsy were the Borogoves - why is "mimsy" an adjective?