Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My data is 10 years of rainfall observations from 3 different meteorological
observation stations. Observation dates are placed in the Row Labels category. Values are placed in the Values category, making av sum of rainfall. The observation stations and actual years are placed in the Report Filter category. I want to group the row labels by months. In Excel 2003 this is easy, just right-click the row label and choose 'month'. In Excel 2007 this seems impossible. Why? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Please see this:
http://office.microsoft.com/training...RC102058721033 Options tab Group Group field should have months. "H.P.Hoeie, Norway" wrote: My data is 10 years of rainfall observations from 3 different meteorological observation stations. Observation dates are placed in the Row Labels category. Values are placed in the Values category, making av sum of rainfall. The observation stations and actual years are placed in the Report Filter category. I want to group the row labels by months. In Excel 2003 this is easy, just right-click the row label and choose 'month'. In Excel 2007 this seems impossible. Why? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - Grouping | Excel Worksheet Functions | |||
Grouping in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Worksheet Functions | |||
Pivot table grouping | Excel Discussion (Misc queries) |