title: Using an OR condition to filter an Excel Pivot Table
body: <p>I'm an Excel amateur and I'm just starting to learn to use Pivot Tables. The issue is, I need the pivot table filtered results to be inclusive.</p>
  
  <p>So, I have a table with some data rows and 3 Columns A, B, C with possible values X, Y, Z... I  specify a filter for columns A, B, C such as that I can retrieve the data rows that have A=Y OR B=Z OR C=X.</p>
  
  <p>The problem I have is that the default filters use an AND condition. So if I select the first value as A=Y, it will remove all other rows.</p>
  
  <p>Any ideas? I know that you can do something similar with an Advanced Filter, but I don't know if there's a simpler solution.</p>
  
  <p>Many thanks!</p>