Pivot Table Filter with Slicer

Using Pivot tables is a great way to summarise your data but say you want a slicer to change the value of a cell.

1. Create a pivot table with and add a slicer.
2. Drag the field you used for the slicer down to the filter.
3. Note that the cell, in this case B2 has been filled with the slicer content.

Should you wish to follow along you can use the Slicer Pivot table exercise file.