Look Who it Was Random video

Excel - Create a Pivot Table for Each Customer Using Show Report Filter Pages - Episode 711

1,398 views · Published 18 February 2009 · 2:08 · Indexed 26 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Create a Pivot Table for Each Customer Using Show Report Filter Pages in Excel.

Welcome to another MrExcel netcast! In this episode, we're going to dive into one of the most amazing tricks in pivot tables - the "Show Pages" feature. If you've been following along with our pivot table series, you know that pivot tables are a powerful tool for analyzing and summarizing large amounts of data. But did you know that you can use pivot tables to create individual reports for each item in a specific field? That's where the "Show Pages" feature comes in.

To demonstrate this feature, I'll start by creating a basic pivot table with "Products" in the rows, "Regions" in the columns, and "Revenue" in the data area. I'll also apply some formatting to make the report more visually appealing. Now, let's say I want to create a separate report for each customer. I'll simply drag the "Customer" field to the report filter section and choose "All" to include all customers in the report.

Next, I'll go to the pivot table tools "Options" dialog and select "Show Report Filter Pages" from the "Options" drop-down menu. This will prompt Excel to create a new worksheet for each customer, with the corresponding data for that customer. In just a matter of seconds, Excel has created 50 new worksheets in my workbook - one for each customer. This is an incredibly efficient way to produce individual reports for each item in a specific field.

The "Show Pages" feature is not new to Excel 2007 - it was also available in Excel 2003 under the "Pivot Table" drop-down menu. But regardless of which version you're using, this feature is a game-changer for anyone working with large amounts of data. So next time you need to create individual reports for each item in a pivot table, remember to use the "Show Pages" feature. Thanks for watching, and be sure to tune in for more helpful tips and tricks in our MrExcel netcast series."

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Do you ever need to produce a report for every customer? This is a snap with pivot tables in Excel 2007. In Episode 711, we take a look at how to use Show Report Filter Pages to replicate a report for every customer.

Table of Contents:
(00:00) Introduction to Pivot Tables 
(00:18) Most Amazing Trick in Pivot Tables 
(00:28) Building a Pivot Table Report 
(00:43) Producing Report for Every Customer 
(01:01) Using "Show Report Filter Pages" 
(01:17) Excel Inserts New Worksheets 
(01:33) Show Report Filter Pages in Excel 2007 
(01:43) Show Pages in Excel 2003 
(01:53) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Building a pivot table report
Creating new worksheets for each customer in Excel
Excel tutorial on pivot tables
Formatting a pivot table
Insert pivot table in Excel
MrExcel netcast on pivot tables
Pivot table tricks and tips
Producing a report for every customer in pivot tables
Using the report filter section in pivot tables
Using the show pages feature in Excel 2003
Using the show report filter pages feature in Excel 2007
YouTube video on pivot tables


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152184/

More from this channel