Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-12-2013, 12:36 PM
mskennedy mskennedy is offline Grouping Dates in Excel Pivot Table Windows 7 64bit Grouping Dates in Excel Pivot Table Office 2010 64bit
Novice
Grouping Dates in Excel Pivot Table
 
Join Date: Feb 2013
Posts: 1
mskennedy is on a distinguished road
Default 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.
Reply With Quote
 

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
Grouping Dates in Excel Pivot Table 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft