Home > Pivot Table > Pivot Table Cannot Group That Selection

Pivot Table Cannot Group That Selection

Contents

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 How can an advanced (circa 7000 AD) spacefaring human civilization be prevented from entering its own solar system? Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. 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 this contact form

Start Date is also used as the data field (Count of Start Date). asked 1 year ago viewed 1353 times active 1 year ago Upcoming Events 2016 Community Moderator Election ends Nov 22 Related 3Add totals line to pivot chart in Excel 20104Excel VBA The solution to this common problem is quite simple and comes in the form of using a dynamic named range . Loading Ozgrid Excel Help & Best Practices Forums

Register Help Remember Me? his explanation

Excel Pivot Table Group Field Grayed Out

Not the answer you're looking for? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Nov 15th, 2011,12:14 AM #7 gepa New Member Join Date Jan 2008 Posts 4 Re: Pivot Table: “Cannot Group ALL purchases totaling over $150.00 gets you BOTH! Will I get the same result if I use 18-55mm lens at 55mm (full zoom) and 55-200mm lens at 55mm (no zoom), if not, then why?

If you don't like Google AdSense in the posts, register or log in above. 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 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. Pivot Table Not Grouping Dates 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

Business Sub-categories Financial reporting Management accounting Finance & strategy Financial reportingSponsored FRS - A new way of working Financial reporting 9am Lowdown: BT takes £145m accounting hit Financial reporting FRS 102: Cannot Group That Selection Excel 2013 Pivot Table While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. Excel Video Tutorials / Excel Dashboards Reports February 11th, 2004 #2 Pesky Weasel View Profile View Forum Posts OZMVP Join Date 7th February 2003 Location Kewarra Beach, Cairns - TNQ Posts http://www.ozgrid.com/forum/showthread.php?t=18319 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

There are currently no replies, be the first to post a reply. Pivot Table Grouping Not Working What is a satisfactory result of penetration testing assessment? 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 Tax The technology revolution or evolution?

Cannot Group That Selection Excel 2013 Pivot Table

This is because Excel does not know what it should do with the one blank cell in regards to grouping with date cells. If the are Right aligned - dates, Left aligned - text. Excel Pivot Table Group Field Grayed Out But you will have to refresh the data TWI... Cannot Group That Selection Excel 2007 Pivot Table 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

But if even just one out of 10,000 or 20,000 date fields is faulty, the Group function refuses to work. weblink Once I moved the field into the main body of the pivot table, I was able to group the dates. FREE Excel Help Here! In the Pivot Table “Start Date” is a Column Field. Excel Cannot Group Columns

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 eg 01/01/04 will change to 37987 if the dates are truly dates. Can a text in Latin be understood by an educated Italian who never had any formal teaching of that language? navigate here 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).

My cat sat on my laptop, now the right side of my keyboard types the wrong characters more hot questions question feed about us tour help blog chat data legal privacy Cannot Group That Selection Pivot Table 2013 If the are Right aligned - dates, Left aligned - text. What now?

Browse other questions tagged excel excel-2010 pivot-table or ask your own question.

Once you have corrected the faulty dates, go into the pivot table and press the Refresh Data button. 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 Ozgrid Retains the Rights to ALL Posts and Threads Microsoft Excel Training- From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS Grouping Excel Pivot Tables | | Information Helpful? Group Dates In Pivot Table Excel 2013 a number) and refreshed your pivot, you won't be able to group the way you want.

eg 01/01/04 will change to 37987 if the dates are truly dates. Possible repercussions from assault between coworkers outside the office Is adding the ‘tbl’ prefix to table names really a problem? Remove rows in table that have rows with missing values Lab colleague uses cracked software. http://amigasuperbit.com/pivot-table/pivot-table-date-group-cannot-group-that-selection.html This column contains only dates.

Though its im too late ,,,,,,Hope this would work ....... To start viewing messages, select the forum that you want to visit from the selection below. 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. Mimsy were the Borogoves - why is "mimsy" an adjective?

Should I report it? 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 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 Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4.

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. I am seen in darkness and in light, What am I? Start Date is also used as the data field (Count of Start Date). Highlight column A, then push Ctrl+G and click Special then check the Blanks option and click OK.

Bhagavad Geeta 4.14 Example for a commutative subring of a non-commutative ring As a monk, can I use Deflect Missiles to protect my ally?