Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Modifying a Pivot Table

After you build a pivot table, you can make changes to it any time. For example, if you want to examine the new clients for a particular month, you need to change the Month field. Use the drop-down list to the right of the field name. Select a month and click OK. This step selects and deselects new clients in the list, and Excel instantly displays new clients broken down by more or less magazines in the DATA area of the pivot table. You also should see the grand total dollar amounts by magazine at the bottom of each item. At the bottom of the table, you should see the grand total for new clients to all magazines.

You can use this report to analyze your data in various ways. For instance, click the PivotTable down arrow ...