Microsoft Office Tutorials and References
In Depth Information
Chapter 17: Working with Pivot Tables
Figure 17-1: This table is a good candidate for a pivot table.
Creating a pivot table
Figure 17-2 shows a pivot table created from the data, along with the PivotTable Field List task
bar. This pivot table summarizes the sales performance by sales representative and month. This
pivot table is set up with the following fields:
Figure 17-2: A pivot table created from the data in Figure 17-1.
h Region: A report filter field in the pivot table.