W
wburbage
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
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