The report filter is fantastic for analysing Excel PivotTable data. It allows you to filter the PivotTable using any field from your data source.

An awesome feature called Show Report Filter Pages will display each report filter result on a different sheet of your workbook. This works great when there are only a few filter criteria.

This feature always goes down well in training sessions. It allows you to quickly and easily create multiple reports on different sheets of a workbook, based on the criteria you want to use.