Home > Pivot Table > Pivot Table Cannot Group By Month

Pivot Table Cannot Group By Month

GO OUT AND VOTE Why is Professor Lewin correct regarding dimensional analysis, and I'm not? Browse other questions tagged microsoft-excel pivot-table or ask your own question. option is greyed out, or that a message box pops up, saying "Cannot Group That Selection", this is usually because the data column in the original data sheet contains one or Think again. Check This Out

If you look at the broken lines moving around the block of data, you will see that they are enclosing a blank row or column somewhere. Though its im too late ,,,,,,Hope this would work ....... 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). If the are Right aligned - dates, Left aligned - text. read this post here

Thanks. Fill Blank Cells Within a List Let's say you have a list of entries in column A and within the list you have many blank cells. Non-Repetitive Quine About the kanji 鱈 C++ calculator using classes Does my 7 segment display need a bypass capacitor?

To test these formating tips for yourself, try them out on your copy of the pivot_practice.xls database. While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. If the blanks are in-between other dates you will need to fill them. Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00.

Purchases MUST be made via this site. The time now is 20:27. Excel Video Tutorials / Excel Dashboards Reports February 11th, 2004 #4 Dave Hawley View Profile View Forum Posts Visit Homepage Administrator Join Date 24th January 2003 Location Australia Posts 31,973 Hi http://www.ozgrid.com/forum/showthread.php?t=18319 When I click "Group Selection" on my invoice dates, I just get the message "Cannot group that selection".

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 i tried to delete that column and row without success. If you have formatting that overide the default alignment on that column you can check by fomatting one of the cells as a number. Possible repercussions from assault between coworkers outside the office How to decline a postdoc interview if there is some possible future collaboration?

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. Clicking Here Yes, I did confirm they are all proper date fields. Any text will be listed before the dates. AccountingWEB Share this content Replies Please login or register to join the discussion.

It blocks us from benefitting from the features of pivot tables. his comment is here Thanks (0) By David Carter 25th Oct 2006 11:48 you have to sort out the Data range in Step 2Ken, The "blank" column definitely proves that Excel is looking at a The data range in the box needs to be adjusted. How would you model 'a sphere with a shell' like object?

Then base the pivot table on this new column and uncheck the bogus date field. microsoft-excel pivot-table share|improve this question edited Oct 7 '12 at 17:19 slhck 126k38322366 asked Oct 7 '12 at 16:52 Mike 611 add a comment| 1 Answer 1 active oldest votes up Should I allow my child to make an alternate meal if they do not like anything served at mealtime? this contact form About the kanji 鱈 more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts

For the past 3 months a pivot table that generates a report has been screwing up in an automated spreadsheet. Think again. A guy scammed me, but he gave me a bank account number & routing number.

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).

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 Can you tell me some possible causes of this error? Any faulty dates will be found in the first and last rows. But you will have to refresh the data TWI...

To start viewing messages, select the forum that you want to visit from the selection below. Since there's no date here, Excel can't group. - the data range seems to contain dates, but they just look like dates. 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 navigate here This worked for me!

And "Group Field" in the ribbon is greyed out. Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums. While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. so i try to change the date to month by following the tips given in excelzone.

But if even just one out of 10,000 or 20,000 date fields is faulty, the Group function refuses to work. Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. share|improve this answer answered May 21 '15 at 21:19 teylyn 12.6k21643 Thank you for your response, but the sort (in the pivot table) sorts by date and all the Registration is FREE and allows you to view all content, ask questions, comment and much more.

Normally, simply going back to your data table, selecting the column which contains what you think is numeric data, changing the alignment to General under Format>Cells>Alignment will force Excel to return Luckily, you don't have to double-click you way down the whole list. I get an error "Cannot group that selection". 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

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 eg 01/01/04 will change to 37987 if the dates are truly dates. ALL purchases totaling over $150.00 gets you BOTH! 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

My cat sat on my laptop, now the right side of my keyboard types the wrong characters Using DSolve with a boundary condition at -Infinity Can an object *immediately* start moving Show that the square matrix A is invertible magento 2: How to use the order by and limit clause in sql query Can Trump undo the UN climate change agreement? Once this is done, you can go back to options, change data source and now you can extend your data range over the empty cells. i dont know where have i gone wrong.

Can you tell me some possible causes of this error? In the Pivot Table “Start Date” is a Column Field. Alternatively, highlight the column and format it as Number.