How do I sort a pivot table page list?
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. |
How do I sort a pivot table page list?
You could create a custom list of the store names, in order of trading
days -- List the stores on the worksheet, sorted by trading days Select the list Choose ToolsOptions, click Custom Lists Click the Import button, then click OK Refresh the pivot table, and make sure the Store Name field is sorted in the custom list order Then, use the Show Pages command. stevekop wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 07:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com