Home > Pivot Table > Pivot Date Cannot Group That Selection

Pivot Date Cannot Group That Selection

Contents

How to delete the lines from a file that do not contain dot? Safety - Improve braking power in wet conditions Start a coup online without the government intervening On which point(s) in a jet engine does the reaction force act? 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 How can I take a powerful plot item away from players without frustrating them? this contact form

On 1941 Dec 7, could Japan have destroyed the Panama Canal instead of Pearl Harbor in a surprise attack? One more step Please complete the security check to access www.accountingweb.co.uk Why do I have to complete a CAPTCHA? Is Area of a circle always irrational What is the most someone can lose the popular vote by but still win the electoral college? After reformatting the date column you should be able to group on that column.

Excel Pivot Table Group Field Grayed Out

I have placed "delivered" in my row labels. This column contains only dates. 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 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

One more step Please complete the security check to access www.ozgrid.com Why do I have to complete a CAPTCHA? And "Group Field" in the ribbon is greyed out. Share it with others Like this thread? Pivot Table Not Grouping Dates How often should I replace windscreen wiper blades?

One more step Please complete the security check to access www.ozgrid.com Why do I have to complete a CAPTCHA? Cannot Group That Selection Excel 2013 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. Select the column, run Text to Columns (in the Data menu or AltAE), Delimited, and Finish. Please try the request again.

This will update the values in the pivot table, and you should now be able to group the selected row or column values.Continue to Part 4 of the Excel Pivot Table Pivot Table Grouping Not Working CloudFlare Ray ID: 2ff93bb2a5145420 • Your IP: 204.152.201.107 • Performance & security by CloudFlare Please enable cookies. I've refreshed the pivot table, I've restarted Excel, but no luck. 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

Cannot Group That Selection Excel 2013 Pivot Table

If you are at an office or shared network, you can ask the network administrator to run a scan across the network looking for misconfigured or infected devices. http://www.mrexcel.com/forum/excel-questions/74642-pivot-table-%93cannot-group-selection%94-error.html 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. 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 Cannot Group That Selection Excel 2007 Pivot Table 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

a number) and refreshed your pivot, you won't be able to group the way you want. weblink Blank cells are also considered to be invalid dates, so you must make sure that there are no blanks. Do Morpheus and his crew kill potential Ones? What can I do to prevent this in the future? Excel Cannot Group Columns

Can you tell me some possible causes of this error? 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 Can I use that to take out what he owes me? http://amigasuperbit.com/pivot-table/pivot-table-date-group-cannot-group-that-selection.html CloudFlare Ray ID: 2ff93bb264f1141f • Your IP: 204.152.201.107 • Performance & security by CloudFlare Jump to content Sign In Create Account Search Advanced Search section: This topic Forums Members Help

My cat sat on my laptop, now the right side of my keyboard types the wrong characters Can a text in Latin be understood by an educated Italian who never had Cannot Group That Selection Pivot Table 2013 Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. When I click "Group Selection" on my invoice dates, I just get the message "Cannot group that selection".

To find it, sort the pivot table (not the source table) by the date column with A-Z as the sort order.

It's either something simple which I've looked over or something incredibly obscure. –ChrisG May 22 '15 at 1:12 Any blanks cells? –teylyn May 22 '15 at 4:15 Completing the CAPTCHA proves you are a human and gives you temporary access to the web property. Straight line equation Alternating Fibonacci Is there a word for being sad about knowing that the things that make you happy will eventually go away Show that the square matrix A Group Dates In Pivot Table Excel 2013 I'm not sure what I'm doing wrong, can you help?

If you are on a personal connection, like at home, you can run an anti-virus scan on your device to make sure it is not infected with malware. 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 What now? his comment is here more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science

CloudFlare Ray ID: 2ff93bb2627220ba • Your IP: 204.152.201.107 • Performance & security by CloudFlare ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve