Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Years in a Pivot table
Hi
I have mastered groups dates by year in my pivot table, but I would like to group them further in groups of 5 years. Any ideas? Using Excel 2003 Thanks Ailish |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Years in a Pivot table
Hi,
Create a new field in the data source =YEAR(C2) where C2 is the first date field entry. Redefine the source of the pivot table to include this new field. Add it as a outer row field. Put your cursor in that new pivot table field and use the PivotTable, Group and Show Details, Group command. In the Grouping dialog box that appear set Starting at to the first year, Ending at to the last year and By to 5. If this helps, please click the Yes button Cheers, Shane Devenshire "Ailish" wrote: Hi I have mastered groups dates by year in my pivot table, but I would like to group them further in groups of 5 years. Any ideas? Using Excel 2003 Thanks Ailish |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Years in a Pivot table
"Ailish" wrote: Hi I have mastered groups dates by year in my pivot table, but I would like to group them further in groups of 5 years. Any ideas? Using Excel 2003 Thanks Ailish |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping Dates in a Pivot table for years that are not calendar ye | Excel Worksheet Functions | |||
pivot table and grouping | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
Pivot table grouping | Excel Worksheet Functions | |||
Pivot Table Fiscal Years | Excel Discussion (Misc queries) |