A Slicer is used to apply a filter to a Pivot Table. It consists of a set of clickable buttons. But what if you want to display the text from the selected button or buttons and display it in a single cell?

This question has been asked several times recently in my Pivot Tables classes. In this video I show you my solution.

Links to the video and individual sections below:


Create a Pivot Table

Connect Pivot Table to the Slicer

Display Selected Item (Single) from the Slicer

Display all the Selected Items from the Slicer