I created a pivot table from the following data:

Salesperson   |   Amount   |   Include?
John          |   100      |   Yes
Jane          |   350      |   Yes
Jim           |   200      |   No
Jack          |   150      |   Yes

My Rows is Salesperson, my Values is Sum of Amount and Include is my Filter. I want the filter to only include values where Include is Yes. This is working fine but I do not want the filter to be visible in the report.

Is it possible to hide this?

Report looks like:

Include?    |    Yes (dropdown) (filter row)
------------------------------- (blank row)
Salesperson |    Sum of Sales   (header row)
Data Here...                    (data rows...)

I do not want the filter row or blank row to show up.

Edit I should also mention that I do not want to hide the entire row in Excel because I have data in different columns that I want to show.