Grouping a timeline in a pivot table by months.

H

H.P.Hoeie, Norway

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table Days to Months 0
calculating differences in a pivot table 3
grouping dates in a pivot table 1
Subtotal percents in pivot table 1
pivot table missing rows? 0
sum by rows in Pivot 1
weekday in pivot table 4
Pivot Table 1

Top