Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Sort | Excel Discussion (Misc queries) | |||
How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Pivot Table dropping items from page item list | Excel Discussion (Misc queries) | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Pivot Table Sort & Top List | Excel Discussion (Misc queries) |