Using a Page Field to Create Reports for Each Region or Product

In addition to row fields, column fields, and data fields, a pivot table can have one or more page fields. A page field goes in a separate set of rows above the pivot report. It can serve to filter the report to a certain region, or a certain customer, or a certain combination of region and customers. Figure 12.37 shows a pivot report showing the top 10 customers for product ABC in the West region.

Figure 12.37

This report has two page fields—Region and Product.The page field serves to filter the pivot table results to one particular region or cus-tomer.In this case, the report shows the top 10 customers for product ABC in the West region.

Region

Pro duel

0 0

Post a comment