Company about
Home > Pivot Table > Pivot Table Grouping Not Working

Pivot Table Grouping Not Working


In the popup menu, click Group In the Grouping dialog box, enter 1 in the Starting At box In this example, the highest number of units is 50, and you can The entry in the Ending at box should be larger or later than the entry in the Starting at box. Click here to pick a date and time: Free PivotTable Webinar Sections Grouping Data Video: Grouping Dates Grouping Dates Grouping Dates by Week Grouping by Date Adds Extra Items Video: Grouping Share it with others Like this thread? check my blog

Because you created the two pivot tables from the same source data, by default they use the same pivot cache, the grouped items are the same in both tables. You group them so that New York and Boston are in one group you name Atlantic, and Los Angeles and Seattle are in a group you name Pacific. To group, you cannot have any, and I mean any, empty cells. [ This Message was edited by: EdE on 2002-04-12 13:49 ] Share Share this post on Digg Technorati Your browser can't show this frame.

Cannot Group That Selection Excel 2010

Less Grouping data in a PivotTable can help you show a subset of data to analyze. 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. For example, suppose you have four cities in the City field: Boston, New York, Los Angeles, and Seattle. Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc.

  1. 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).
  2. So, instead of 3 and 9 appearing in separate rows, they'll be summarized in the grouping 1-10.
  3. Or, add new fields in the source data, to calculate the year and year/month, for each date, and use the new fields in the pivot table, instead of grouping.
  4. Browse other questions tagged excel date ssas grouping pivot-table or ask your own question.
  5. Opened up a pivot-table on AdventureWorks to see what that does.
  6. 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

For 'Number of days', select 7 The week range is determined by the date in the 'Starting at' box, so adjust this if necessary. Generated Tue, 15 Nov 2016 04:45:50 GMT by s_fl369 (squid/3.5.20) Microsoft Excel Training- From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS Grouping Excel Pivot Tables | | Information Helpful? About grouping data in a PivotTable When you group data in a PivotTable, be aware that: You can’t group items for Online Analytical Processing (OLAP) source data that doesn't support the Pivot Table Not Grouping Dates Results 1 to 4 of 4 Thread: [Solved] Pivot Tables : “Cannot Group That Selection” error Thread Tools Show Printable Version Search Thread Advanced Search February 11th, 2004 #1 steveski

HTH. Excel Pivot Table Group Field Grayed Out Watch this video to see the steps for creating groups from text items. BTW, it's best to start with the field that you want to group as a row field. -- C^2 Conrad Carlberg Excel Sales Forecasting for Dummies, Wiley, 2005 "Bill B" I clicked on the “Start Date” In the Column Filed area and selected Grouping by Month & Year.

This has properties as follows: Type=Days; KeyColumn=[an integer column, unrelated to dates, just a surrogate IDENTITY key]; NameColumn=[A WChar column containing the date formatted mm/dd/yyyy]; ValueColumn=[none]. Excel Cannot Group Columns Ozgrid Retains the Rights to ALL Posts and Threads current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts. Your browser can't show this frame.

Excel Pivot Table Group Field Grayed Out

There is nothing wrong with the data, it just so happens that there is no date against a lot of the records. More Bonuses This feature isn't available in a normal Excel pivot table (see the workaround in the next section). Cannot Group That Selection Excel 2010 Highlight column A, then push Ctrl+G and click Special then check the Blanks option and click OK. Cannot Group That Selection Excel 2013 Pivot Table 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

April 12th - 18th: Free webinar, Mastering Pivot Tables -- Learn how to set up data and create a Pivot Table in less than 3 minutes. I thought this data, in combination with my machine locale settings (European date format dd/mm/yyyy) might be confusing Excel, so I changed the locale to US through Control Panel and reopened Skip to main content Login Cart Exceljet Quick, clean, and to the point Training Videos Functions Formulas Shortcuts Blog Search form Search 10 pivot table problems and easy fixes With pivot I suggest that you start another pivot table from scratch (because you will already have stored a null date in the existing pivot table's cache) and pull in the data using Cannot Group That Selection Excel 2007 Pivot Table

Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money Special! Grouping Dates by Week To group the items in a Date field by week Right-click on one of the dates in the pivot table. Not the answer you're looking for? news eg 01/01/04 will change to 37987 if the dates are truly dates.

In the Number of days box, click 7, and then click Months. Excel Pivot Table Group By Month Not Working asked 1 year ago viewed 4034 times active 1 year ago Upcoming Events 2016 Community Moderator Election ends in 8 days Blog Stack Overflow Podcast #94 - We Don't Care If In the popup menu, click Group In the Grouping dialog box, select one or more options from the 'By' list.

Then, you should be able to group the date field again.

To group the numbers Right-click on one of the unit numbers in the pivot table. I hoped I'd find out through AdventureWorks, but that doesn't work either. While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. Excel Group Greyed Out 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 time now is 05:43. Sum of PCBA Buy Monday Date Total 3/4/02 300 3/11/02 3/18/02 3/25/02 4/1/02 4/8/02 4/15/02 12 4/22/02 12 4/29/02 5/6/02 5/13/02 5/20/02 5/27/02 6/3/02 6/10/02 6/17/02 461 6/24/02 7/1/02 7/8/02 7/15/02 Download the sample file for this video: Your browser can't show this frame. Now push Equals (=) then the Up arrow and finally holding down the Ctrl key push Enter.

The zipped file is in xlsx format, and does not contain macros. PivotTable Field List after time grouping Notes: When you drag a date field from the Field List to the Rows or Columns area where a field already exists, and then put the Group items by weeks first, making sure Days is the only time period selected. This is the 3rd video in this series on Pivot Tables.

Once grouped together, you can drag the group to your Pivot Table and start your analysis. To ungroup a single group: Right-click on an item in the group Click Ungroup, and the group reverts to individual items.