Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to re-sort a pivot table filter
I maintain a file that includes one data tab and then about 20 pivot tables
running off that data. So when I run a new report I simply replace the data and refresh the tables. Most of the reports are based on the "project" field which includes roughly 1,200 different projects and increases on a monthly basis. Since there's contantly new projects being added to the data the new project gets placed on the bottom of the pivot table filter. So if I'm looking for a particular project the filter itself may or may not be in order. Is there a way to re-sort the filters within a pivot table filter so this project list is once again in order? Thanks, Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivot Table - Sort Report Filter Values | Excel Discussion (Misc queries) | |||
how do I control the sort order of a filter in a pivot table? | Excel Discussion (Misc queries) | |||
Sort choices in filter in pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions |