title: Excel VBA - Pivot Table with Multiple Value Filters
body: <p>Is there a way in Excel VBA to allow for multiple value filters in a Pivot Table?  I'm trying to filter values for >0 AND for Bottom Ten items. In the sample code below (generated by recording a Macro), the second filter step overrides the first.  If multiple value filters were supported, it seems I would only need to add the Boolean logic AND between these two expressions to get the product of both filters. Please suggest any changes to the code or let me know if this is not supported.  Thanks!</p>
  
  <pre><code>Sub Multiple_Value_Filters()
  
      ActiveSheet.PivotTables("PivotTable1").PivotFields("Full Name").PivotFilters.Add _       
          Type:=xlValueIsGreaterThan, _
          DataField:=ActiveSheet.PivotTables("PivotTable1").PivotFields("Days"), _
          Value1:=0
      ActiveSheet.PivotTables("PivotTable1").PivotFields("Full Name").ClearAllFilters
      ActiveSheet.PivotTables("PivotTable1").PivotFields("Full Name").PivotFilters.Add _
          Type:=xlBottomCount, _
          DataField:=ActiveSheet.PivotTables("PivotTable1").PivotFields("Days"), _
          Value1:=10
  End Sub
  </code></pre>