- Excel Book Excerpt
Excel Limit a Report to Just One Region
This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Limit a Report to Just One Region
Problem: I need to send a customer report such to each regional manager in my company. I want each manager to see only sales in his or her region.
Strategy: You can use the Report Filter area of the pivot table to create such a report. You drag the Region field to the Report Filter drop zone in the lower half of the PivotTable Field List dialog. It seems like nothing has really changed. All the numbers in the pivot table are the same. But, there is a new Region dropdown in row 1.
Figure 853 Initially, the report still shows all regions.
Open the dropdown next to Region. You can select any one region, or using the new checkbox, select multiple regions.
Figure 854 Select one region.
Choose East from the Region dropdown. The report will update to show just the customers from the East region. You can print this report and send it to the East regional manager.
Figure 855 The report shows only sales for East.
To produce the report for Central, you simply change the Region dropdown from East to Central. You can repeat for each other region.
For more resources for Microsoft Excel: