title: Applying Multiple Value Filters in Excel Pivot
body: <p>Using Excel 2013, I would like to apply a Top 10 Filter to a pivot and also apply a filter to an additional values field.  Is this possible?
  I would like to filter off all 1's from Sum of Individual Claims Column, but still have the top 10 by average of % of claims (minus the claim volumes that were only 1).</p>
  
  <p>Table 1 with 1's in Sum of Individual Claims Column</p>
  
  <p><a href="https://i.stack.imgur.com/C7Yvo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/C7Yvo.png" alt="enter image description here"></a></p>
  
  <p>The resulting table should look like this.</p>
  
  <p><a href="https://i.stack.imgur.com/QH04U.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QH04U.png" alt="enter image description here"></a></p>