How can I show in descending order data that is drilled down in a pivot table
and opened as a new worksheet? There does not seem to be a sorting format
that Excel uses...seems random to me. For example, I want users to see their
highest values when they drill down in the pivot table.