Microsoft Excel 2019 Inside Out

Chapter 16Using 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 have been quietly evolving over the past several versions of Excel. Excel 2010 pivot tables introduced a visual filter called a slicer. Slicers enable you to perform ad-hoc analysis by choosing various items from various fields in the pivot table. Excel 2013 added a new date-centric visual filter called a timeline.

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 ...