excel 2010 cannot group that selection error Chidester Arkansas

Computer and Electronic Services

Address Camden, AR 71701
Phone (877) 238-1053
Website Link
Hours

excel 2010 cannot group that selection error Chidester, Arkansas

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 To start viewing messages, select the forum that you want to visit from the selection below. Any text will be listed before the dates. If you feel it's particularly relevant, provide a link to the other thread.

of ABC's raised,responded, closed by ACR and in a monthly, weekly or yearly basis. In the United States is racial, ethnic, or national preference an acceptable hiring practice for departments or companies in some situations? Please try the request again. I have a field called "delivered" formatted as date and I'm 99% confident it's actually a date. =TYPE confirmed it as a number, used Datevalue and posted over the source to

I am badly in need of solutions for this. FREE Excel Help Here! All contents Copyright 1998-2016 by MrExcel Consulting. Here is the FAQ for this forum. + Reply to Thread Results 1 to 6 of 6 Pivot Table Error: 'CANNOT GROUP THAT SELECTION' Thread Tools Show Printable Version Subscribe to

Pivot_Wont_Group.jpg Register To Reply 06-13-2012,02:09 PM #2 ChemistB View Profile View Forum Posts Forum Guru Join Date 08-05-2004 Location NJ MS-Off Ver MS 2007, 2010 Posts 11,754 Re: Pivot Table Error: And what about "double-click"? 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 microsoft-excel pivot-table share|improve this question edited Oct 7 '12 at 17:19 slhck 125k38315362 asked Oct 7 '12 at 16:52 Mike 611 add a comment| 1 Answer 1 active oldest votes up

What is that the specific meaning of "Everyone, but everyone, will be there."? 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 Templates and Calculators The Way of the Weasel Download Ivan & Colo's HTML Maker Here 101 Excel Hacks - Great New Book Huge Savings on Excel Training February 11th, 2004 #3 Start Date is also used as the data field (Count of Start Date).

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 Thanks. Is there a role with more responsibility? Browse other questions tagged excel excel-2010 pivot-table or ask your own question.

Can you tell me some possible causes of this error? All rights reserved. Please help. Register To Reply 09-20-2012,11:35 AM #6 kbaruin View Profile View Forum Posts Registered User Join Date 09-11-2012 Location UK MS-Off Ver Excel 2003 Posts 81 Re: Pivot Table Error: 'CANNOT GROUP

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 I'm not sure why this happens. The temptation is always there to make your data range for your Pivot Table extend well past the last row of information in your table and thus include many blank cells. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Nov 14th, 2011,11:14 PM #7 gepa New Member Join Date Jan 2008 Posts 4 Re: Pivot Table: “Cannot Group

I have placed "delivered" in my row labels. Start Date is also used as the data field (Count of Start Date). However, I do have blanks in the column, and I've been told that will produce the error I'm getting. For more information about grouping pivot tables by text, see Expert Skills Lesson 5-19 Group by text.

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 a number in a text field). If the blanks are in-between other dates you will need to fill them. When I click "Group Selection" on my invoice dates, I just get the message "Cannot group that selection".

What are Imperial officers wearing here? While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. All rights reserved. In the Pivot Table “Start Date” is a Column Field.

Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. Any advice you have for a more elegant solution is welcome. Luckily, you don't have to double-click you way down the whole list. Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money Special!

However, the date field I was trying to group was located in the Page Field section (top left corner filters). For example, if you had a column for dates for Date of Birth and within that column somewhere there was only one blank cell, Excel would not allow us to group Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 10th, 2004,05:28 PM #4 Juan Pablo González MrExcel MVP Join Date Feb 2002 Location Bogota, Colombia Posts 11,959 I'd run the pivot on one half of the data, then on the other half, then in increasingly smaller chunks of data, until I can identify the culprit. –teylyn May 22

For more about grouping pivot tables by dates, see Expert Skills Lesson 5-20 Group by date. Unfortunately you have inadvertently broken one of the forum rules. After reformatting the date column you should be able to group on that column. Thanks very much for your reply.

I see how I can solve this problem using a Calculated Item. Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. (0 members and