Hi all,
Is it possible to filter a column pivot table with multiple values without having to manually checking each one off? The pivot table contains about 1000 employee IDs and would like to filter out about 50 without having to go through the entire list? Does this need to be done with a macro? Would it also be possible to filter with a 50 employee IDs on another sheet? Hope this makes sense. TIA!