I'm trying to have the details of a pivot table sorted on a certain field (that is not part of the pivot selection).
My pivot comes directly from an external connection to SQLOLEDB, and even if I sort the source query, doesn't seem like excel cares.

*details of a pivot = all the records behind the pivot, when you doubleclick one of the values.