Ordering chronologically in a pivot table

I have dates, and a number corresponding on those dates. I want to try and find the average number for each quarter, so I created a pivot table. My problem is that the pivot table is ordered by the first digit, instead of chronologically and I cant seem to fix this. The sort option doesn't help.
Screenshot: http://i.imgur.com/duoNai7.png


Edit:
In short what I want to accomplish:
1. Order dates chronologically in the pivot table
2. Group dates by quarter
3. Find the average rate for each quarter

Using this excel sheet:
http://ubuntuone.com/3WinjDvrwyumHUeZm2c5Cs

Hi,

Not quite sure without seeing your actual sheet, but that first entry (29.02.1988) is inconsitent with the rest and I would guess is therefore in text, not date, format, which may cause you issues.

Regards

Unfortunately without seeing an actual Excel sheet it's going to be quite difficult to help you.

Regards

I must be doing something wrong but all I see is 4 pictures in there. Can you direct me to the actual spreadsheet itself?

Sorry if I've missed it.

Regards

Strange, clicking that link should bring up the spreadsheet with the option to download as follows: http://i.imgur.com/ORXaWvz.png

Anyway I've uploaded it to ubuntu one as well:
http://ubuntuone.com/3WinjDvrwyumHUeZm2c5Cs

Hi,

The second hyperlink does not open either.

Regards

it's the Discount rate, not showing as number - you have spaces in there!

=TRIM(SUBSTITUTE(E3,CHAR(160),CHAR(32)))*1


This will remove the Unicode character for space and the 'usual' one. The *1 converts the result to a number. Update your pivot table to be looking at this new column, and your all good.