I get an error "Cannot group that selection". You will be likely to find the culprit. –teylyn May 26 '15 at 14:13 | show 2 more comments Your Answer draft saved draft discarded Sign up or log in Share Share this post on Digg Del.icio.us Technorati Twitter Regards, Juan Pablo González http://www.juanpg.com Reply With Quote Feb 10th, 2004,06:21 PM #3 steveski Board Regular Join Date Feb 2004 Posts 55 What happens when a wizard tries to cast a cone of cold through a wall of fire? this contact form
Home Tax Sub-categories Personal tax Business tax HMRC & policy Tax MTD: The impact on your accounting firm and... What is the most someone can lose the popular vote by but still win the electoral college? Thanks. I have placed "delivered" in my row labels. http://www.ozgrid.com/Excel/grouping-pivot-tables.htm
Registration is FREE and allows you to view all content, ask questions, comment and much more. The system returned: (22) Invalid argument The remote host or network may be down. How to Group so you don't get: Cannot Group that Selection See Also: Excel Subtotals || Making the SUBTOTAL Function Dynamic || Bold Excel Subtotals Automatically || Sum Every Nth Cell Pivot Table Not Grouping Dates All contents Copyright 1998-2016 by MrExcel Consulting.
To test these formating tips for yourself, try them out on your copy of the pivot_practice.xls database. Cannot Group That Selection Excel 2013 Pivot Table However, the date field I was trying to group was located in the Page Field section (top left corner filters). Merge Or Convert Excel | Trading Add-ins For Excel | Convert Excel Into Web Pages | Convert Databases Including Excel | Business Spreadsheets | Build Automatic Trading Models in Excel Quick When I select the drop down for Row Labels "Date Filters" is an option that appears.
I have sorted it to confirm that it's sorting as a date. Pivot Table Grouping Not Working 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 Not the answer you're looking for? Your cache administrator is webmaster.
And "Group Field" in the ribbon is greyed out. http://www.excelfunctions.net/group-pivot-table.html If you have formatting that overide the default alignment on that column you can check by fomatting one of the cells as a number. Excel Pivot Table Group Field Grayed Out Can I use that to take out what he owes me? Cannot Group That Selection Excel 2007 Pivot Table 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.
If the are Right aligned - dates, Left aligned - text. weblink Is adding the â€˜tblâ€™ prefix to table names really a problem? 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 it with others Like this thread? Excel Cannot Group Columns
This worked for me! However, I do have blanks in the column, and I've been told that will produce the error I'm getting. 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. navigate here Any faulty dates will be found in the first and last rows.
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 Pivot Table 2013 To start viewing messages, select the forum that you want to visit from the selection below. 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 have a Pivot Table based on the data entry sheet. Also, the time in the original cell is in an unknown format. Not the answer you're looking for? his comment is here Tax The technology revolution or evolution?
This is because Excel does not know what it should do with the one blank cell in regards to grouping with date cells. C# TBB updating metadata value Can a president win the electoral college and lose the popular vote Will I get the same result if I use 18-55mm lens at 55mm (full 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 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
For more about grouping pivot tables by dates, see Expert Skills Lesson 5-20 Group by date. 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). Check for faulty dates by sorting the database into date order. If you have any questions regarding the content of this notice, please contact a member of the OzGrid Administration Team If this is your first visit, be sure to check out
While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. I clicked on the “Start Date” In the Column Filed area and selected Grouping by Month & Year. What legal documents are Italian citizens supposed to carry when traveling to Ireland? eg 01/01/04 will change to 37987 if the dates are truly dates.