hide filter in pivot table

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.

1 Answer

Create a pivot table place the "include?" field to the column and the salesperson field to the row.

Drag the salesperson to the value and use the count function.