Analyzing Data Dynamically with PivotTables

Excel 2007 worksheets enable you to gather and present important data, but the standard worksheet can’t be changed from its original configuration easily. As an example, consider the worksheet in the following graphic.

This worksheet records monthly package volumes for each of nine distribution centers in the United States. The data in the worksheet is organized so that each row represents a distribution center, whereas the columns in the body of the worksheet represent a month of the year. When presented in this arrangement, the monthly totals for all centers and the yearly total for each distribution center are given equal billing: neither set of totals stands out.