O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required