pivot table data

R

richzip

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
 
K

Kevin B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Surpressing rows and columns with zero values in a pivot table 1
Pivot Table Data 1
Pivot table bottom ten filter with conditions 2
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table 2
Pivot table data layout - columns to rows 1
Adding to an existing Pivot Table 7
pivot table data 2

Top