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

Pivot Table Dates Cannot Group That Selection

Contents

Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013. Here is the FAQ for this forum. + Reply to Thread Results 1 to 7 of 7 Cannot Group that selection Problem Thread Tools Show Printable Version Subscribe to this Thread… This one can be a little bit hard to spot at times, but just remember by default numbers are right aligned and text is left aligned. 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 this contact form

I am using excel 2003 Register To Reply 01-04-2005,06:06 PM #2 Debra Dalgleish Guest Re: Cannot Group that selection Problem Perhaps a blank row is included at the end of the Thanks. To start viewing messages, select the forum that you want to visit from the selection below. Select the column, run Text to Columns (in the Data menu or AltAE), Delimited, and Finish. a fantastic read

Excel Pivot Table Group Field Grayed Out

The time now is 07:37 AM. How can an advanced (circa 7000 AD) spacefaring human civilization be prevented from entering its own solar system? 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 I'm not sure what I'm doing wrong, can you help?

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. Browse other questions tagged microsoft-excel pivot-table or ask your own question. Can you tell me some possible causes of this error? Pivot Table Grouping Not Working 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

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 Cannot Group That Selection Excel 2013 Pivot Table FREE Excel Help Here! If I double click on all of them, all will finally be on the right side of cells – it works for grouping and then sorting by hours. Originally It did not due to data in row 2000.

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 Pivot Table Not Grouping Dates a date column such as: Column A 2/5/08 3/6/08 4/19/08 N/A 6/17/08 Will not be able to be grouped because of the "N/A" entry. You may have to register before you can post: click the register link above to proceed. Originally It did not due to data > in row 2000.

Cannot Group That Selection Excel 2013 Pivot Table

I clicked on the “Start Date” In the Column Filed area and selected Grouping by Month & Year. http://www.excelfunctions.net/group-pivot-table.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 In the source data and the pivot table > , I have formatted the date field to show the full day eg > Saturday,January 1, 2005 instead of 1/1/2005. > What Cannot Group That Selection Excel 2007 Pivot Table Someone peeled an American flag sticker off of my truck.

But you will have to refresh the data TWI... weblink I'm baffled on this. Obviously you would do this so when you add more information to your table it would automatically be included in your Pivot Table the moment you refresh it. Several functions may not work. Excel Cannot Group Columns

Basically, what this means is your column must: Have no blank fields Your data range for your Pivot Table should not exceed past the last row of data. For more details on dates & numbers seen as text see:Convert Dates || Excel Calendar for Valid Dates || Excel Date and Times || Converting Text Numbers to Real Numbers Pivot While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. http://amigasuperbit.com/pivot-table/pivot-table-cannot-group-that-selection-dates.html 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

Basically, that didn't turn up any stray text values. Cannot Group That Selection Pivot Table 2013 Story where dome is erected freezing people in time - one person gets trapped outside Oracle SQL - can I return the "before" state of a column value How does Gandalf Tax The technology revolution or evolution?

You will have to enter in 'dummy' data into fields that do not fit the norm of the rest of the column.

About the kanji 鱈 Mimsy were the Borogoves - why is "mimsy" an adjective? Pivot tables won't allow you to group dates if there are any invalid dates within the data source. Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums. Group Dates In Pivot Table Excel 2013 Thanks.

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 checked the formats of the data by Format=>>Cell=> Date. But if even just one out of 10,000 or 20,000 date fields is faulty, the Group function refuses to work. his comment is here Remove the capital letters from my posted email address, to get the real address.

You can now refresh the pivot and should be able to group. 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 The > range includes all cells I expected. ALL purchases totaling over $150.00 gets you BOTH!

From there at the bottom will be a list of all of the entires in that column and you can choose to hide certain entries. 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