Eliminating/Hiding rows in pivot table

[Cole9420]

[FONT=&quot]I am trying to exclude rows from a pivot table that have data in a particular column. Filtering just removes the data in the column, but not he entire row. How do I remove or hide the entire row from the table? Below is an example of the data. In this case I want to remove the rows that have data in column E so only the rows with Donor 1,3,6,7 should remain. Thanks for the help.


[/FONT]

	2012	2013	2014	2015	2016
Donor 1	100	50		85
Donor 2				1000	1000
Donor 3	500	250	250	500
Donor 4	100	150			50
Donor 5	25	25	25	25	25
Donor 6	1000		1500	2500
Donor 7				5000

<colgroup><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

 

[Cole9420]

To clarify: I want to remove the rows that have data in column F