Slicer In Pivot Table Excel How To Insert Slicers

The purpose of Slicer in excel is to filter the data present in a pivot table.

The data can be presented based on various categories with the help of this slicer as it offers a way to apply the filters on the pivot table that dynamically changes the view of the pivot table data.

Rows section has the table field whose data should be displayed for the selected column.

Values field displays the actual values to display which the pivot table is prepared for.

E.g. SUM, PRODUCT, AVERAGE, etc.

Since we have to display the Fruits records, will select Fruit from the slicer.

Here, AppleBananaMango are the Products whereas FruitVegetable are the Categories.

Rows section has Country selected and Columns section has Product.

The Values section has Sum of Quantity selected as we have to display the total sales for each fruit across the countries.

The Grand Total Row at the last displays the Total sales of a given Fruit for all the Countries.

Multiple slicers are used those are the product, country, and category.

Ideally, more slicers in the pivot table, more granular data visualization in Excel is possible.

Slicer In Pivot Table Excel How To Insert Slicers

Here we discuss how to insert slicers in a Pivot Table in Excel along with practical examples and downloadable excel template.

CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Slicer In Pivot Table Excel For Mac