Have a look at the attached sheet which contains a small pivot table.

I have used the slicer which is found on the Insert Tab.

You can choose the slicer to filter pages, columns and rows in the pivot table.