M
martinghale
We are looking for information on how to provide a multi value report
filter using a Pivot Table in Excel 2007.
Here's the scenario:
A user is analyzing auto crash data using an Excel 2007 pivot table.
Once they get down to a targeted small data set, they execute the
Drillthrough action which returns detail for each crash including a
Crash ID Number. Let's say the total returned is 50 records.
The user now has a list of 50 Crash ID Numbers that they want to do
further analysis. Using the Pivot Table Report Filter function, we
can select the Crash ID Number field and then right-click to bring up
what type of filter we want to use. Ideally we would see a "list" but
there is not that option. We tried to separate multiple values in the
"Contains" options but it didnt' like that.
There are far too many values for Crash ID Number (several million) to
simply expand and select the ones we want. We need a way to 'pass'
them to the filter.
Any ideas or suggestions would be greatly appreciated!
filter using a Pivot Table in Excel 2007.
Here's the scenario:
A user is analyzing auto crash data using an Excel 2007 pivot table.
Once they get down to a targeted small data set, they execute the
Drillthrough action which returns detail for each crash including a
Crash ID Number. Let's say the total returned is 50 records.
The user now has a list of 50 Crash ID Numbers that they want to do
further analysis. Using the Pivot Table Report Filter function, we
can select the Crash ID Number field and then right-click to bring up
what type of filter we want to use. Ideally we would see a "list" but
there is not that option. We tried to separate multiple values in the
"Contains" options but it didnt' like that.
There are far too many values for Crash ID Number (several million) to
simply expand and select the ones we want. We need a way to 'pass'
them to the filter.
Any ideas or suggestions would be greatly appreciated!