| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Distributing Pivot Tables where pivot table data can't be accessed | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
Linear Mode
