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

Pivot Table Grouping Cannot Group That Selection

Contents

A story behind a weird inductor Does my 7 segment display need a bypass capacitor? Generated Thu, 10 Nov 2016 11:40:07 GMT by s_hp90 (squid/3.5.20) {{offlineMessage}} Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Software Office Windows Additional software For the past 3 months a pivot table that generates a report has been screwing up in an automated spreadsheet. 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. this contact form

Ballpark salary equivalent today of "healthcare benefits" in the US? Please Login or Register to read the full article The full article is available to registered AccountingWEB.co.uk members only. While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. Can I use that to take out what he owes me?

Excel Pivot Table Group Field Grayed Out

The other common reason for not being able to group data is that you have both text and numeric data in the same field. I get an error "Cannot group that selection". 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 Home Tax Sub-categories Personal tax Business tax HMRC & policy Tax MTD: The impact on your accounting firm and...

asked 4 years ago viewed 7428 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 It blocks us from benefitting from the features of pivot tables. {{offlineMessage}} Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Software Office Windows Additional software Apps All apps Windows apps Windows phone apps Games Xbox Pivot Table Not Grouping Dates 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

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). Cannot Group That Selection Excel 2013 Pivot Table 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 I'm not sure why this happens. http://www.ozgrid.com/forum/showthread.php?t=18319 Then base the pivot table on this new column and uncheck the bogus date field.

I have a Pivot Table based on the data entry sheet. Pivot Table Grouping Not Working Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Highlight column A, then push Ctrl+G and click Special then check the Blanks option and click OK. Here is some of my data: Thanks, Natalie Jensen Back to top Report #2 Jonathan Jonathan Forums Administrator Administrators 758 posts Posted 30 September 2013 - 04:20 PM Hi Natalie,

Cannot Group That Selection Excel 2013 Pivot Table

Several functions may not work. How to delete the lines from a file that do not contain dot? Excel Pivot Table Group Field Grayed Out 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 Cannot Group That Selection Excel 2007 Pivot Table 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

Please try the request again. weblink All rights reserved. How do I "lock" my Linux box for few hours? Tax The technology revolution or evolution? Excel Cannot Group Columns

Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. Can you tell me some possible causes of this error? Ozgrid is Not Associated With Microsoft. navigate here While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine.

Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not Cannot Group That Selection Pivot Table 2013 This is the reason I come to this site. Grouping Pivot Table Data.

Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.

Check for faulty dates by sorting the database into date order. The first, and most likely cause, is due to the fact that your Pivot Table data range includes blank cells within the field in which you are trying to group. This is because Excel does not know what it should do with the one blank cell in regards to grouping with date cells. Group Dates In Pivot Table Excel 2013 Fill Blank Cells Within a List Let's say you have a list of entries in column A and within the list you have many blank cells.

a number) and refreshed your pivot, you won't be able to group the way you want. There are currently no replies, be the first to post a reply. 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 http://amigasuperbit.com/pivot-table/pivot-table-date-group-cannot-group-that-selection.html 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

But if even just one out of 10,000 or 20,000 date fields is faulty, the Group function refuses to work. After reformatting the date column you should be able to group on that column.