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

Question

Computers & Technology

Kale Gonzalez

9 October, 07:59

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

+2

Answers (2)

Know the Answer?

Lawson Frey · 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.

Giana Strong · 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.

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.