Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Exclude bulk set of values from the filter of a pivot table


Hi team,

I have a query (O2/1channel), similar to a pivot table. This table returns data for let's say 1k customer codes. If I need to exclude from the filter a high number of codes like 200, how to do it without having to tick one by one in the value filter's list or without having to process it manually outside the pivot table (e.g. vlookup)? And the list to be excluded does not behave according to a rule (e.g. greater than, top x). Thanks.

0 Replies