grouping in pivot table 1

[CCNProjects]

Hello.

I have an excel sheet with the following exchange rate data
01 jan 1999 0.1
02 jan 1999 0.5
...
30 dec 2007 0.2
31 dec 2007 0.3

I could not group the dates and get an average exchange rate per year. The error I get is: Could not group that selection.

I formatted my first column as date, and checked if my second column was formatted as numbers. But it does not work!
Any hint is appreciated.

 

[GlennUK]

Are you sure that the first column is all dates, with no blanks or text strings in any cells?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[CCNProjects]

Thanks.
My problem was my data and not the pivot table.

 

[GlennUK]

Great! Have had that problem myself in the past.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.