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

[Gageon_Phillips_Chen98]

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.

[#2]

@Gageon_Phillips_Chen98 

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

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