Using Pivot tables is a great way to summarise your data but say you want a slicer to change the value of a cell.
Should you wish to follow along you can use the Slicer Pivot table exercise file.