Pivot table: How to use same data for filter and column header

Hi,

I have a list of S/N with Pass/Fail result next to it. A specific S/N can appear several times in the list:

SN...Result
-------------
111...FAIL
111...FAIL
111...FAIL
111...PASS
222...PASS
333...FAIL
333...FAIL

When creating a pivot table of SN vs. Result (count) I get:

****|FAIL...PASS
-------------------
111..|...3.....1
222..|..........1
333..|...2

I want to get the FAIL count of SN in which PASS > 0 (First two rows)

BUT I can not figure out how I can filter based on the values of the pivot table itself (rather than the values of the original list).
When I try to use 'Result' field as report filter, I can not get it as a Column label (and vice-versa). In this case I get:

I get:
****|PASS
------------
111 | ...1
222 | ...1

Desired:

.......|..FAIL..PASS
-------------------
111 |...3...1
222 |........1

Desired (alternative):

......|..FAIL
-------------
111 |...3
222 |...0


Any advice would be appreciated.