Pivot Table Report Filter - "OR" instead of "AND" Multiple Filters

[tommcbrny]

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?

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Logic OR Filter.
http://www.mediafire.com/file/acbtzuwxg4x/10_28_09a.xlsm