How to add multiple criteria in the “exclude” function of item filtering in PivotTable report?

%3CLINGO-SUB%20id%3D%22lingo-sub-2719772%22%20slang%3D%22zh-CN%22%3EHow%20to%20add%20multiple%20criteria%20in%20the%20%E2%80%9Cexclude%E2%80%9D%20function%20of%20item%20filtering%20in%20PivotTable%20report%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719772%22%20slang%3D%22zh-CN%22%3E%3CP%3EIn%20the%20%E2%80%9DExclude%E2%80%9C%20option%20of%20label%20filter%2C%20I%20want%20to%20add%20multiple%20conditions%20to%20the%20exclude%20option%2C%20for%20example%2C%20B%20is%20not%20included%20while%20A%20is%20not%20included.%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20implement%20it%20in%20PivotTable%3F%3C%2FP%3E%3CP%3EAs%20shown%20in%20the%20figure%2C%20if%20I%20only%20use%20commas%20to%20separate%2C%20I%20can't%20realize%20that%20it%20doesn't%20contain%20multiple%20fields%20and%20items.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2719772%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2726457%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%20multiple%20criteria%20in%20the%20%E2%80%9Cexclude%E2%80%9D%20function%20of%20item%20filtering%20in%20PivotTable%20report%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2726457%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1146654%22%20target%3D%22_blank%22%3E%40Gageon_Phillips_Chen98%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E6%98%AF%E7%9A%84%EF%BC%8C%E6%9C%89%E4%B8%80%E7%A8%AE%E6%96%B9%E6%B3%95%E5%8F%AF%E4%BB%A5%E5%AF%A6%E7%8F%BE%E5%AE%83%EF%BC%8C%E4%BD%86%E4%B8%8D%E8%83%BD%E5%9C%A8%E6%95%B8%E6%93%9A%E9%80%8F%E8%A6%96%E8%A1%A8%E4%B8%AD%E5%AF%A6%E7%8F%BE%EF%BC%8C%E5%A6%82%E6%9E%9C%E4%B8%8D%E5%88%B7%E6%96%B0%E6%95%B8%E6%93%9A%E9%80%8F%E8%A6%96%E8%A1%A8%E5%B0%B1%E7%84%A1%E6%B3%95%E6%9B%B4%E6%94%B9%E5%AE%83%EF%BC%8C%E6%82%A8%E5%BF%85%E9%A0%88%E4%BD%BF%E7%94%A8%E4%B8%8D%E5%90%8C%E7%9A%84%E6%95%B8%E6%93%9A%E6%BA%90%E9%87%8D%E6%96%B0%E5%89%B5%E5%BB%BA%E6%95%B8%E6%93%9A%E9%80%8F%E8%A6%96%E8%A1%A8%E3%80%82%3C%2FP%3E%3CP%3E%E5%A6%82%E6%9E%9C%E6%82%A8%E6%9C%89%E8%88%88%E8%B6%A3%E4%BA%86%E8%A7%A3%E8%A7%A3%E6%B1%BA%E6%96%B9%E6%B3%95%EF%BC%8C%E8%AB%8B%E5%91%8A%E8%A8%B4%E6%88%91%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

In the ”Exclude“ option of label filter, I want to add multiple conditions to the exclude option, for example, B is not included while A is not included.

Is there any way to implement it in PivotTable?

As shown in the figure, if I only use commas to separate, I can't realize that it doesn't contain multiple fields and items.

1 Reply

@Gageon_Phillips_Chen98 

 

是的,有一種方法可以實現它,但不能在數據透視表中實現,如果不刷新數據透視表就無法更改它,您必須使用不同的數據源重新創建數據透視表。

如果您有興趣了解解決方法,請告訴我。