Sipmle pivot table won't sort

Hi,
I have a simple pivot table:

source data
ID name date
1 name1 12.1.2013
2 name2 14.1.2013
3 name3 13.1.2013

My Pivot table is only meant for sorting (filetring etc.) the data according to the date. There are no "values".

Desired result
ID name date
1 name1 12.1.2013
3 name3 13.1.2013
2 name2 14.1.2013

But it won't work. The button indicates a sorted column, but the order is still 1,2,3 instead of 1,3,2.

The source data "date" column is formatted as date.
Excel 2010.

Thanks for any suggestions.

I moved the column and it worked! I don't get the logic behind this, but I don't care.
Thank you guys!

Ok, this logic is simple . But not really obvious. I mean, the sort option should be grayed-out in other columns. Or rather should not (current state) and should sort .

1) Of course, some sort combinations do not make sense. But then I'd expect the PT to make the rules more obvious. Columns sholudn't be marked as sorted if there is something preventig them from sorting. The blocking should rather be overriden by the latter choice or somehow explictely reffered to, so that it can be removed manually.

2) In my case I use the PT as dynamic table of ten bigest clients sorted according various parametres. It may not be what PT were intended for, but I think it's a clear solution. I think, it wouldn't do any harm to the original PT purpose if such a top 10 table was arbitrarily soratble.

You're right. In my case the date column actually was sorted, only within the parent field. I didn't tealize that. My bad. And my apologies to PT logic . Thanks.