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? |
Pivot Table Report Filter - "OR" instead of "AND" MultipleFilters
|
All times are GMT +1. The time now is 03:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com