Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? I do not have missing, blank, or error values in the source data for the field "delivered." With all that said, when I right click on a date value in the I'm baffled on this. Any other feedback? this contact form
For more about grouping pivot tables by dates, see Expert Skills Lesson 5-20 Group by date. Purchases MUST be made via this site. To change a group label, click it, press F2, and type the name you want. Register To Reply 09-20-2012,09:52 AM #4 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
Once I moved the field into the main body of the pivot table, I was able to group the dates. Group date and time columns automatically (time grouping) Note:Â The time grouping feature is available in Excel 2016 only. Check for faulty dates by sorting the database into date order. In the Starting at and Ending at box, enter this (as needed): The smallest and largest number to group numeric fields.
For a data model PivotTable, when you drag a date field with over one thousand rows of data from the Field List to the Rows or Columns areas, the Date field 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. This is the reason I come to this site. Pivot Table Grouping Not Working 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
However, the date field I was trying to group was located in the Page Field section (top left corner filters). Cannot Group That Selection Excel 2013 Pivot Table Several functions may not work. When I click "Group Selection" on my invoice dates, I just get the message "Cannot group that selection". 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 This will update the values in the pivot table, and you should now be able to group the selected row or column values.Continue to Part 4 of the Excel 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 Pivot Table Not Grouping Dates For example, you may want to group an unwieldy list of dates or times (date and time fields in the PivotTable) into quarters and months, like this: Note:Â The time grouping feature Though its im too late ,,,,,,Hope this would work ....... 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
Thanks. http://www.excelfunctions.net/group-pivot-table.html Yes No Great! Excel Pivot Table Group Field Grayed Out This is consistent with how PivotTable undo worked in previous releases. Cannot Group That Selection Excel 2007 Pivot Table a number in a text field).
Thanks. weblink I did not have any empty spaces and all of my dates were formatted properly. I am getting an error which reads 'CANNOT GROUP THAT SELECTION' when trying to use the 'Group' feature on a field in a pivot table. LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Excel Cannot Group
You can only group numbers. I have placed "delivered" in my row labels. 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, navigate here 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
Any faulty dates will be found in the first and last rows. Cannot Group That Selection Pivot Table 2013 Once grouped together, you can drag the group to your Pivot Table and start your analysis. Not the answer you're looking for?
For example, you can group by Months and Weeks. For example, when the Date field is checked in the Fields list above, Excel automatically adds Year, Quarter, and month (Date) as shown below. Instant Download and Money Back Guarantee on Most Software Microsoft Excel Training- From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS Excel Trader Package Technical Analysis in Excel With $139.00 Group Dates In Pivot Table Excel 2013 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
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 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 Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 10th, 2004,06:28 PM #4 Juan Pablo González MrExcel MVP Join Date Feb 2002 Location Bogota, Colombia Posts 11,959 Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00.
Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013. Is Area of a circle always irrational Why is looping over find's output bad practice? Also, the time in the original cell is in an unknown format. THanks Originally Posted by Cutter Hello kbaruin, and welcome to the forum.
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. Not the answer you're looking for? I have a Pivot Table based on the data entry sheet. Don't post a question in the thread of another member -- start your own thread.
Polyglot Anagrams Robbers' Thread Do the Leaves of Lórien brooches have any special significance or attributes? 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 You first need to ungroup the items, add the calculated item, and then regroup the items. See Also Create a PivotTable in Excel 2016 to analyze worksheet data Training video: Group data in PivotTables Share Was this information helpful?