pivot table data
 

I have a large spreadsheet of employees and hours worked and convert that
into a pivot table. Is there a way of excluding certain employees from the
pivot table, without deleting them from the main spreadsheet? Could I maybe
"tag" those employees with an indicator in certain column; if that column
contains that value I would like to exclude them from the pivot table.

Thanks

pivot table data
 

You can deselect them in the pivot table by dropping down the list of
employees from the employee column or row and removing the check mark from
their name or employee id, whatever you're using to indicate an employee.
--
Kevin Backmann


"richzip" wrote:

I have a large spreadsheet of employees and hours worked and convert that
into a pivot table. Is there a way of excluding certain employees from the
pivot table, without deleting them from the main spreadsheet? Could I maybe
"tag" those employees with an indicator in certain column; if that column
contains that value I would like to exclude them from the pivot table.

Thanks