To filter data in a PivotTable,follow the series of selections: A cell in the PivotTable Analyze Insert Slicer Select the fields you want to create slicers for OK Select the items you want to show in the PivotTable.

Question

To filter data in a PivotTable,follow the series of selections: A cell in the PivotTable > Analyze > Insert Slicer > Select the fields you want to create slicers for > OK > Select the items you want to show in the PivotTable.

Quizplus · Accepted Answer

This series of selections is correct for filtering data in a PivotTable using slicers.

To Filter Data in a PivotTable,follow the Series of Selections