How to sort a pivot table with VBA?

[vanclute]

I'm using Mac Excel 2011, trying to sort a pivot table but it's not behaving.

I found this thread:

[SOLVED] Excel 2011 - Trying to Sort Pivot Table

and tweaked the code to suit my names of things:

Worksheets("performance").PivotTables(1).PivotFields("date").AutoSort xlDescending, "Row Labels"

but it doesn't do a thing. No errors either... not sure what the trouble might be. Anyone have any suggestions?

My field name is "date" and the caption on the pivot table itself is "Row Labels".

 

[vanclute]

Furthermore, when I sort by recording a macro, I end up with:

ExecuteExcel4Macro "(1,,2,2,1)"

However trying to play it back, results in an error 1004. Why would the macro recorder produce code that it can't play back itself?