Slicer

A set of buttons that filters a Pivot Table on one field (PivotTable Analyze > Insert Slicer). It shows the current selection at a glance and can drive several pivots at once.

When to use

Slicers suit fields with few categories, such as Category or Branch; a numeric field like Commission with thousands of distinct values gives an unusable button list. A slicer only controls the pivots ticked in Report Connections.

See Lec 07.

Appears in

No references yet.