From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Breaking out report filter pages

Breaking out report filter pages - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Breaking out report filter pages

“

- [Instructor] The last thing I want to cover in this section is a tool called report filter pages, and this isn't a really well known tool. It's not that commonly used, but in cases where you do need to use it, it can save you a ton of time. So essentially you would use the show report filter pages option to create new tabs for each value that any given filter can take. In the screenshots we're looking at here, we've got a filter for year that can take three values. 2011, 2012, or 2013. By using the show report filter pages, and selecting that year filter, excel will automatically create a brand new tab with that filter set to each of its possible values. So in this case, we'd end up with three new tabs, one for the year 2011, one for year 2012, and one for the year 2013. So it saves the time and effort of manually changing those filters, replicating and copying a tab, and then starting over again. So let's jump into our pivot and give this a shot. Okay, so here we go, first things…

Contents