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

T

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Customizing charts for different stakeholders. 2
moving multiple fields in one table to one field in another table 1
Help Customizing Project Management Database Template 5
Visual Basic and Excel 5
Pivot Table Clear All Filters 8
date filter in a pivot table 1
One pivot table cannot overlap another pivot issue. 1
Are Date filters available for items in the Filter area of pivot t 2

Top