4. A dialog box will appear, asking you to show all Report Filter Pages and giving you a list of all the fields in the Report Filter. Even though this seems silly when you have only one field in the Report Filter area, choose Customer and click OK.
Results: In a matter of seconds, Excel will add a new worksheet for each customer. Each worksheet will be named after the customer, and the Customer dropdown will be changed to the particular customer. In a matter of seconds, you will have one worksheet for each customer.
Figure 858 One report per customer.
Gotcha: Get the pivot table perfect before making hundreds of copies. Even though I thought I did a lot of formatting, I forgot to replace blanks with zeroes in the above figure. At this point, I would delete the customer worksheets, change the original pivot table, then use Show Pages again.
You can imagine that this feature could be useful if you need one report per department, one report per product, etc.