16. Using Slicers and Filtering 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. 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 ...

Get Excel 2016 In Depth now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.