Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Pivot Table Filter Issue
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot Table Multi Value Filter | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot Table Filter (multi value) | Excel Discussion (Misc queries) | |||
add filter to pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table issue in Excel 2007 | Excel Discussion (Misc queries) |