en uk

Summing a pivot table Microsoft Excel 2007

    A pivot table not only displays information, but it can also count the number of occurrences of information, such as the number of sales per sales region. To display a count of data, you need to move a heading in the Values group inside the PivotTable Field List pane by following these steps:

    1. Click the pivot table you want to modify.

    The PivotTable Field List pane appears.

    2. Click a heading that you want to count in the PivotTable Field List pane. A pop-up menu appears.

    3. Click Move to Values.

    Excel moves your chosen heading to the Values group inside the PivotTable Field List pane and displays a count of items under your chosen heading, as shown in Figure 9-20.

    Summing a pivot
table Microsoft Excel 2007

    Figure 9-20:

    A pivot table can count occurrences of certain data, such as the number of different products sold by each salesperson.




BACK NEXT TOP

Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.