Home > Pivot Table > Pivot Table Cannot Group This Selection

Pivot Table Cannot Group This Selection

All rights reserved. ALL purchases totaling over $150.00 gets you BOTH! Can you tell me some possible causes of this error? Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search this contact form

That is Cool! Any advice you have for a more elegant solution is welcome. The time now is 20:48. This is because Excel does not know what it should do with the one blank cell in regards to grouping with date cells.

Regards Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 3rd, 2013,11:33 AM #10 PaulR42 New Member Join Date Dec 2013 Posts 1 Re: Pivot Table: “Cannot more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed It's aligned on the left side of the cell and if I double click on the cell, the time will jump to the right side. I clicked on the “Start Date” In the Column Filed area and selected Grouping by Month & Year.

I'm not sure what I'm doing wrong, can you help? Thanks. GO OUT AND VOTE How does Gandalf end up on the roof of Isengard? Please try the request again.

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 You may have to widen your column a little, to actually see whether your data is left aligned (text) or right aligned (numbers). Grouping Pivot Table Data. http://www.ozgrid.com/forum/showthread.php?t=18319 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.

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 Should I allow my child to make an alternate meal if they do not like anything served at mealtime? 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. Tax Tolley's Tax Hub Practice Sub-categories Practice strategy General practice Skills Practice strategySponsored Coming soon: Turn your practice into a niche firm Practice strategySponsored Accounting Fees in 2016: 3 facts Think

If you have formatting that overide the default alignment on that column you can check by fomatting one of the cells as a number. http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/cannot-group-data-for-date-fields-in-a-pivot-table/fe380d63-446d-e011-8dfc-68b599b31bf5 Browse other questions tagged microsoft-excel pivot-table or ask your own question. And until you've converted all cells from text-looking-like-time to actual time (i.e. 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.

Ozgrid Retains the Rights to ALL Posts and Threads Register Help Remember Me? weblink However, I do have blanks in the column, and I've been told that will produce the error I'm getting. Share this content Related content {{item['sft-title']}} Advertisement Get AccountingWEB in your inbox You might also like {{item['sft-date']}} {{item['sft-section']}} {{item['sft-title']}} Trending on AccountingWEB {{item['sft-section']}} {{item['sft-title']}} Practice Excellence Practice Excellence: Tayabali Tomlin Our When I click "Group Selection" on my invoice dates, I just get the message "Cannot group that selection".

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 Thanks. Can you tell me some possible causes of this error? navigate here I have a Pivot Table based on the data entry sheet.

I've refreshed the pivot table, I've restarted Excel, but no luck. This, depending on how many extra rows you include, can end up increasing your file size by 100% or greater. eg 01/01/04 will change to 37987 if the dates are truly dates.

Now push Equals (=) then the Up arrow and finally holding down the Ctrl key push Enter.

Start Date is also used as the data field (Count of Start Date). When does TNG take place in relation to DS9? 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 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

Highlight column A, then push Ctrl+G and click Special then check the Blanks option and click OK. Advanced Search Forum HELP FORUMS Excel General [Solved] Pivot Tables : “Cannot Group That Selection” error Excel Training / Excel Dashboards Reports IMPORTANT INFORMATION The OzGrid Free Excel & VBA Help Can Trump undo the UN climate change agreement? http://amigasuperbit.com/pivot-table/pivot-table-date-group-cannot-group-that-selection.html However, I do have blanks in the column, and I've been told that will produce the error I'm getting.

If you have formatting that overide the default alignment on that column you can check by fomatting one of the cells as a number. 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 Yes, I did confirm they are all proper date fields. Luckily, you don't have to double-click you way down the whole list.

The system returned: (22) Invalid argument The remote host or network may be down. Let's address these common problems and tell you the reasons as to why they occur. The time now is 07:48 AM. Any advice for getting the pivot table to ignore the blanks?

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 If the blanks are in-between other dates you will need to fill them. Thanks Paul Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Page 1 of 2 12 Last Jump to page: « Previous Thread | Next Thread » Like 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.

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 Can a president win the electoral college and lose the popular vote About the kanji 鱈 On 1941 Dec 7, could Japan have destroyed the Panama Canal instead of Pearl Harbor The whole column should be converted to numbers. 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

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 Advanced Excel Integration XL-Dennis corner in the Excel-world OTHER STUFF DAVE HAWLEY FOUNDATION Newsletters Competitions HAV-A-CHAT Book Suggestions & Reviews Test Area Excel Development & Consultancy EXCEL SEARCH & RESOURCES Excel Compare Excel | Excel Templates | DownloaderXL Pro Finance Templates & Add-In Bundle | NeuroXL Predictor | Construction Estimating Merge Excel The Easy Way | Trading Add-ins For Excel Back to top Report Back to Pivot Tables Also tagged with one or more of these keywords: pivot table, cannot group that selection Free Excel consultancy for ExcelCentral.com members → Pivot

Now push Equals (=) then the Up arrow and finally holding down the Ctrl key push Enter. To start viewing messages, select the forum that you want to visit from the selection below. This worked for me! Basically, that didn't turn up any stray text values.