Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money Special! Perhaps we'll spot an issue. > > > > > > > > > *********** > > > Regards, > > > Ron > > > > > > XL2003, WinXP 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. 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 have a peek here
If I double click on all of them, all will finally be on the right side of cells â€“ it works for grouping and then sorting by hours. Sign Up Now! The whole column should be converted to numbers. 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
If you don't like Google AdSense in the posts, register or log in above. Can you tell me some possible causes of this error? Perhaps we'll spot an issue. > > > *********** > Regards, > Ron > > XL2003, WinXP > > > "Marion" wrote: > > > I am working in a pivot
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 & 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 My cat sat down on my laptop, now the right side of my keyboard types the wrong characters Why did Borden do that to his wife in The Prestige? Pivot Table Not Grouping Dates Purchases MUST be made via this site.
When I click "Group Selection" on my invoice dates, I just get the message "Cannot group that selection". Excel Pivot Table Group Field Grayed Out All contents Copyright 1998-2016 by MrExcel Consulting. Will not even give me the option to choose month, year,etc. http://www.mrexcel.com/forum/excel-questions/74642-pivot-table-%93cannot-group-selection%94-error.html Perhaps we'll spot an issue. >>>> >>>> >>>>*********** >>>>Regards, >>>>Ron >>>> >>>>XL2003, WinXP >>>> >>>> >>>>"Marion" wrote: >>>> >>>> >>>>>I am working in a pivot table, dragged my dates in from
Can you tell what steps are you following? Cannot Group That Selection Pivot Table 2013 However, the date field I was trying to group was located in the Page Field section (top left corner filters). The ages range from 5 to 16 years.If you want to group the ages into the age ranges 5-8 years, 9-12 years and 13-16 years, you can this as follows:Right click Any advice you have for a more elegant solution is welcome.
All rights reserved. http://superuser.com/questions/484616/cannot-group-that-selection-error-when-creating-pivot-table Keep geeting a > > "cannot group that selection" error when I try to group dates. Cannot Group That Selection Excel 2010 However, I do have blanks in the column, and I've been told that will produce the error I'm getting. Cannot Group That Selection Excel 2007 Pivot Table 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
a number) and refreshed your pivot, you won't be able to group the way you want. http://kelcours.com/pivot-table/excel-pivot-table-date-cannot-group-that-selection.html The time now is 06:20 PM. Why do cars die after removing jumper cables? Post a sample of your "dates". Excel Cannot Group Columns
Hello and welcome to PC Review. Pivot Table Grouping Not Working Regards, AM Register To Reply 04-13-2015,10:45 AM #5 newdoverman View Profile View Forum Posts Forum Guru Join Date 02-07-2013 Location Port Dover, Ontario, Canada MS-Off Ver 2010 Posts 10,044 Re: Pivot Thanks.
Why is this? 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 Remember Me? Excel Pivot Group By Month And Year Also, the time in the original cell is in an unknown format.
Regards, AM Register To Reply 04-13-2015,06:26 AM #4 ashishmehra2010 View Profile View Forum Posts Forum Contributor Join Date 03-11-2014 Location India MS-Off Ver Excel 2010 Posts 379 Re: Pivot table cannot Grouping pivot tables by text is a similar feature that allows pivot tables to be grouped by text values. I took out > > > all blanks. this contact form Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
© Copyright 2017 kelcours.com. All rights reserved.