To use more than one filters per field,one can right-click a cell in the pivot table,and click PivotTable Options,then click the Layout & Format tab.Finally,under Filters,add a check mark to "Allow multiple filters per field" and click OK.

Question

Quizplus · Accepted Answer

The Answer of To use more than one filters per field,one can right-click a cell in the pivot table,and click PivotTable Options,then click the Layout & Format tab.Finally,under Filters,add a check mark to "Allow multiple filters per field" and click OK.

To Use More Than One Filters Per Field,one Can Right-Click