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.