#1
|
|||
|
|||
Grouping Dates in Excel Pivot Table
I'm working with a pivot table in Excel 2010. I have a date field as my Row Label. I'm trying to Group these dates by Month and Year, but it's not working. When I right-click and select "Group", I should get options to Group By Month, Year, etc. Instead, it just creates a group called "Group1" without giving me the date options. I've used these date groups in other pivot tables, but can't see any difference with this one. Any ideas? thanks. |
#2
|
|||
|
|||
Hi
Are you able to post a sample so we can take a look for you. Tony |
#3
|
||||
|
||||
Any blanks in your fields? Are some of your dates not real dates but text looking like dates?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
date, group |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Pivot Table Calculated Field | BertLady | Excel | 0 | 05-21-2012 10:51 AM |
Is this kind of grouping possible in Excel? | Jamal NUMAN | Excel | 0 | 02-14-2012 03:09 PM |
Excel 2010 Pivot Table Qs | SchneeBaer | Excel | 2 | 10-03-2011 08:45 PM |
Excel pivot table into an MS Word Doc "office 2007" | wmarsh3561 | Excel | 1 | 01-09-2010 08:03 PM |
How to do grouping in Excel | volcane | Excel | 2 | 04-30-2005 09:23 PM |