Pivot Table Data Filter
 

I have pivot table linked to a network database source that shows the payroll
information for management. The challenge is I do not want all of the data
viewable to all managers such as each other's salaries. Is there any way I
can check the autofilter dropdown to show what I want then protect that
filter? I appreciate your help.