Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Chapter 16

Using slicers and filtering a pivot table

Filtering using the row label filter

Filtering using slicers

Filtering dates

Filtering oddities

Sorting a pivot table

Pivot table filters, including the visual slicer and date-centric timeline, allow you to analyze only a portion of your data.

Filtering using the row label filter

To follow along, create a new pivot table from the 16-Slicers.xlsx file. Check the Customer, Date, Quantity, Revenue, COGS, and Profit fields. On the Design tab, open the Report Layout drop-down menu. Choose Tabular form and then choose Repeat All Item Labels. Choose the Banded Rows check box on the Design tab. You will end up with the pivot table shown in Figure 16.1. Drop-down lists in cells A3 and B3 lead to ...