Hi there,
I use the Pivot tables "Show pages" Tool but the pages will be shown only in
alphabetical order.

My page field is "store names" and the table contains data "number of days
the store has been trading for" (as a data field), amongst other data such as
sales broken down by period.

How can I create these "Store Name" multiple worksheets to display in order
of "Number of days trading", instead of alphabetically by store name?

Can Anyone help?
Steve.