View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Grouping a timeline in a pivot table by months.

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?