Timeline Slicers are a new addition to Excel 2013. They are a new filter tool that is available exclusively to the date fields in your PivotTables. They are visually appealing and easy to use.
To use a Timeline with your PivotTable;
Timeline Slicers are a new addition to Excel 2013. They are a new filter tool that is available exclusively to the date fields in your PivotTables. They are visually appealing and easy to use.
To use a Timeline with your PivotTable;
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.
[Read more…] about Show PivotTable Report Filter on Different Sheets