Use report filter tabs in Microsoft Excel PivotTables to quickly parse and analyze your data.
You can use the report filter aka page filter feature in Excel to give you one additional way to filter and refine your Excel PivotTable information. You can also quickly create a breakdown of the report filter options into separate spreadsheets that will then display each of those individual filter results. This will allow you to create multiple separate reports or spreadsheets that you could then send off to various departments or people.
