LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Pivot Table - Grouping Dates Error

Hi there -
I had my pivot table all set up for the past couple years and all of a
sudden yesterday the woman taking over for my job lost the grouping of dates
on one of my sheets. Now it just lists every date and the sales amounts
associated with each individual date, rather than before where it was grouped
by year, and month.

I tried to right click on my 'Date' colum and go to group; but every time I
hit Group i get an error saying that it's unable to group this selection. I
went through and made sure all my dates were filled in, no blank cells, and
still unable to group. Suggestions?? Please??? It's driving me CRAZY!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Grouping DAtes in Pivot Tables berby65 Excel Discussion (Misc queries) 4 December 1st 06 11:52 PM
Grouping dates in a pivot table Fred Smith Excel Worksheet Functions 2 March 15th 06 01:59 AM
Pivot Table Grouping Santhosh Mani Excel Worksheet Functions 1 January 25th 06 03:12 PM
Pivot table grouping of dates in row fields will not work. Why? Bill B Excel Worksheet Functions 2 September 10th 05 12:23 AM
Grouping Dates in Pivot tables Andy M Excel Discussion (Misc queries) 8 March 26th 05 05:01 PM


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"