Home > Pivot Table > Pivot Table Group By Date Cannot Group That Selection

Pivot Table Group By Date Cannot Group That Selection

Contents

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 After reformatting the date column you should be able to group on that column. I clicked on the “Start Date” In the Column Filed area and selected Grouping by Month & Year. asked 4 years ago viewed 7427 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 http://amigasuperbit.com/pivot-table/pivot-table-date-group-cannot-group-that-selection.html

There are currently no replies, be the first to post a reply. Is adding the ‘tbl’ prefix to table names really a problem? Tax The technology revolution or evolution? 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

Excel Pivot Table Group Field Grayed Out

Registration is FREE and allows you to view all content, ask questions, comment and much more. How can I take a powerful plot item away from players without frustrating them? Should I report it? 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

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 I am > using a dynamic name range and there are no blanks fields on the pivot > table or the dynamic data range. All rights reserved. Pivot Table Grouping Not Working It blocks us from benefitting from the features of pivot tables.

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 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 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 I am seen in darkness and in light, What am I?

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. Pivot Table Not Grouping Dates Your cache administrator is webmaster. While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. In the Pivot Table “Start Date” is a Column Field.

Cannot Group That Selection Excel 2013 Pivot Table

PFL wrote: > The pivot table source is a dynamic range.I checked the format of all > the dates and they are recognised as date format in the pivot table > Visit Website 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 Excel Pivot Table Group Field Grayed Out Start Date is also used as the data field (Count of Start Date). Cannot Group That Selection Excel 2007 Pivot Table Obviously, it will be quite common once you have created a Pivot Table of data that you would be adding new information to that table on an ongoing basis.

Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Sep 11th, 2013,02:00 AM #9 ahamed Board Regular Join Date Jan 2011 Posts 112 Re: Pivot Table: “Cannot Group his comment is here Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013. 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 share|improve this answer answered Oct 8 '12 at 16:08 nutsch 1,478613 1 You may need to remove and re-add the field to the Pivot Table before it will group, I Excel Cannot Group Columns

Boss sends a birthday message. 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 widen your column a little, to actually see whether your data is left aligned (text) or right aligned (numbers). this contact form 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

Double quote value assignments stored in a CSV? Cannot Group That Selection Pivot Table 2013 However, I do have blanks in the column, and I've been told that will produce the error I'm getting. If the are Right aligned - dates, Left aligned - text.

If the blanks are in-between other dates you will need to fill them.

Help? :( excel excel-2010 pivot-table share|improve this question asked May 21 '15 at 17:39 ChrisG 368415 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Looks Please Login or Register to read the full article The full article is available to registered AccountingWEB.co.uk members only. Normally, simply going back to your data table, selecting the column which contains what you think is numeric data, changing the alignment to General under Format>Cells>Alignment will force Excel to return Group Dates In Pivot Table Excel 2013 Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New?

Several functions may not work. Register To Reply 01-04-2005,06:06 PM #4 Debra Dalgleish Guest Re: Cannot Group that selection Problem Have you verified that the dynamic range includes only the cells you expected? Browse other questions tagged excel excel-2010 pivot-table or ask your own question. navigate here 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

Using our same example: Column A 2/5/08 3/6/08 4/19/08 1/1/99 6/17/08 Will allow you to create the grouping. - But what if you don't want your dummy data displayed? Any text will be listed before the dates. In the Pivot Table “Start Date” is a Column Field. You may have to register before you can post: click the register link above to proceed.

This column contains only dates. The resulting pivot table is shown below:Ungrouping a Pivot TableTo ungroup the values in a pivot table, simply:Right click on left column of the pivot table (containing the grouped values);Select the Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel General [SOLVED] Cannot Group that selection Problem To get replies by The other common reason for not being able to group data is that you have both text and numeric data in the same field.

Using DSolve with a boundary condition at -Infinity Why were pre-election polls and forecast models so wrong about Donald Trump? Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. The whole column should be converted to numbers. I get an error "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. OzGrid is in no way associated with Microsoft Some of our more popular products are below...Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates &