| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Report Filter - "OR" instead of "AND" Multiple Filters
Hello,
I have a data source with several columns that may contain data I want. For example, there are multiple stakeholders for each project and the stakeholder i am interested in may appear in "stakeholder 1" or "stakeholder 2" or "Stakeholder 3" or so on. I create a pivot table and add the stakeholder fields to the Report Filter, but the table "AND"s the columns, so the pivot shows only rows where my stakeholder is named in all stakeholder fields selected. Can I change this so the report filter does an "OR" and shows all rows where my stakeholder appears? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Report Filter - "OR" instead of "AND" MultipleFilters
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Can I "customize" an autoformat report for a Pivot Table in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
