Limit a Report to Just One Region
January 04, 2023 - by Bill Jelen
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.
Open the dropdown next to Region. You can select any one region, or using the new checkbox, select multiple regions.
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.
To produce the report for Central, you simply change the Region dropdown from East to Central. You can repeat for each other region.
This article is an excerpt from Power Excel With MrExcel
