title: Filtering pivot table columns, only count if
body: <p>I was wondering if it's possible to filter a single pivot table column in excel.
  In other words, when you summarize the data <strong>by count</strong>, that the data for a certain column is only counted if it has a certain value. </p>
  
  <p>I know that it's possible to get these values by report filtering, but then I need a separate pivot table for the values I don't want to be filtered.  Also, some values are 0 and thus are not displayed if report-filtered. Changing the option to display 0 values doesn't change anything. Thanks in advance.</p>