Question

What are three steps to Filter Data in a Pivot Table?

Answer 1

1.Select a cell in the PivotTable. Select Analyze > Insert Slicer .

2.Select the fields you want to create slicers for. Then select OK.

3.Select the items you want to show in the PivotTable.

Answer 2

Select a cell in the PivotTable. Select Analyze > Insert Slicer .

Select the fields you want to create slicers for. Then select OK.

Select the items you want to show in the PivotTable.

Step-by-step explanation:

Select a cell in the PivotTable. Select Analyze > Insert Slicer .

Select the fields you want to create slicers for. Then select OK.

Select the items you want to show in the PivotTable.