• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 18. Working with Pivot Tables > Modifying a Pivot Table

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 button on the PivotTable toolbar, choose PivotTable Wizard, and click the Layout button. Drag the buttons off the diagram, and arrange the fields like this: Magazine in the PAGE area, Month in the COLUMN area, New Clients in the DATA area, and Responses in the ROW area. The completed PivotTable dialog box should look like the one in Figure 18.7.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint