118k views
2 votes
What are three steps to Filter Data in a Pivot Table?

User Topanga
by
6.5k points

2 Answers

2 votes
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.
User PeterDanis
by
5.9k points
1 vote

Answer:

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.

User Patrick Dattilio
by
6.2k points