Home > Pivot Table > Pivot Table Cannot Group That Selection Dates

Pivot Table Cannot Group That Selection Dates

Contents

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

Excel Pivot Table Group Field Grayed Out

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 I've had the same experience in the past, come to think of it. –nutsch Oct 9 '12 at 16:06 add a comment| Your Answer draft saved draft discarded Sign up Start Date is also used as the data field (Count of Start Date). If you don't like Google AdSense in the posts, register or log in above.

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.

Cannot Group That Selection Excel 2013 Pivot Table

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

Excel Video Tutorials / Excel Dashboards Reports February 11th, 2004 #2 Pesky Weasel View Profile View Forum Posts OZMVP Join Date 7th February 2003 Location Kewarra Beach, Cairns - TNQ Posts

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 You can now refresh the pivot and should be able to group. 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 Group Dates In Pivot Table Excel 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

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.