Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot grouping
I know that in previous versions of Excel (I am on 03), there was a way to
set a date field to automatically show the weeks, months, years etc. as a grouping for that field. In other words, if my field is all dates, I remember being able to set something that said "show me the dates summarized by the following period" (so to speak). Is that gone, or found elsewhere that I am not looking? Thx. -- Boris |
#2
|
|||
|
|||
Right-click on a date field button
Choose Group and Show Detail Group BorisS wrote: I know that in previous versions of Excel (I am on 03), there was a way to set a date field to automatically show the weeks, months, years etc. as a grouping for that field. In other words, if my field is all dates, I remember being able to set something that said "show me the dates summarized by the following period" (so to speak). Is that gone, or found elsewhere that I am not looking? Thx. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping in Excel on a Pivot table, need to be able to retrive ex. | Excel Discussion (Misc queries) | |||
Using Date Grouping in Pivot Tables | Excel Discussion (Misc queries) | |||
grouping data in a pivot table | Excel Discussion (Misc queries) | |||
Grouping Dates in Pivot tables | Excel Discussion (Misc queries) | |||
Date Format Pivot Grouping | Excel Discussion (Misc queries) |