The entry in the Ending at box should be larger or later than the entry in the Starting at box. Skip navigation UploadSign inSearch Loading... This, depending on how many extra rows you include, can end up increasing your file size by 100% or greater. Danny Rocks 32,820 views 5:43 Pivot Table - Super Trick - Duration: 6:48. get redirected here

Excel Pivot Table Group Field Grayed Out

Sign in Transcript Statistics 44,501 views 57 Like this video? Can I use that to take out what he owes me? Select the column, run Text to Columns (in the Data menu or AltAE), Delimited, and Finish.

Loading... The first and last date or time you want to group by. MyExcelOnline.com 407,062 views 1:04:15 How to Generate Multiple Reports from One Pivot Table - Duration: 8:27. Pivot Table Not Grouping Dates 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.

Help? :( excel excel-2010 pivot-table share|improve this question asked May 21 '15 at 17:39 ChrisG 368415 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Looks Cannot Group That Selection Excel 2013 Pivot Table I did not have any empty spaces and all of my dates were formatted properly. After reformatting the date column you should be able to group on that column. Why should/does(?) statistical sampling work for politics (e.g.

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 & Cannot Group That Selection Pivot Table 2013 MrDatamart 50,953 views 7:58 Slaying Excel Dragons Book #40: Grouping Dates in PivotTables: Years, Months or Weeks, and more - Duration: 11:46. Grouping pivot tables by text is a similar feature that allows pivot tables to be grouped by text values. Pivot tables won't allow you to group dates if there are any invalid dates within the data source.

Cannot Group That Selection Excel 2013 Pivot Table

ExcelIsFun 31,124 views 5:25 Excel Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012 - Duration: 55:13. 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 Excel Pivot Table Group Field Grayed Out How do I typeset multiple additions nicely? Cannot Group That Selection Excel 2007 Pivot Table In the Pivot Table “Start Date” is a Column Field.

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 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. Am I interrupting my husband's parenting? useful reference If you ungroup a group of selected items, only the selected items are ungrouped.

Though its im too late ,,,,,,Hope this would work ....... Pivot Table Grouping Not Working asked 4 years ago viewed 7399 times active 4 years ago Related 1Excel pivot table group all months by year2Dates not recognized as dates in pivot table pulling directly from SQL You may have to widen your column a little, to actually see whether your data is left aligned (text) or right aligned (numbers).

To change a group label to something more meaningful, click it, > Field Settings, and in the Custom Name box, type the name you want.

Ungroup grouped data To remove grouping, right-click any item in the grouped data, and click Ungroup. 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 microsoft-excel pivot-table share|improve this question edited Oct 7 '12 at 17:19 slhck 126k38321366 asked Oct 7 '12 at 16:52 Mike 611 add a comment| 1 Answer 1 active oldest votes up Group Dates In Pivot Table Excel 2013 For fields that are organized in levels, you can only group items that all have the same next-level item.

It's aligned on the left side of the cell and if I double click on the cell, the time will jump to the right side. Pivot Table Products Pivot Table Assistant for Microsoft Excel | Pivot Table XL Stat | O2OLAP for Excel Still Need Help? I'm not sure what to do here This is the table, I only need colums B and C. this page The time now is 04:03 AM.

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. Luckily, you don't have to double-click you way down the whole list. Also, the time in the original cell is in an unknown format. Share it with others Like this thread?

I'm baffled on this. 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 You can now refresh the pivot and should be able to group. 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