Microsoft Office Tutorials and References
In Depth Information
Step1: Specifying the data location
Row field: A field that has a row orientation in the pivot table. Each item in
the field occupies a row. You can have nested row fields. In the figure,
Branch and AcctType both represent row fields.
Source data: The data used to create a pivot table. It can reside in a
worksheet or an external database.
Subtotals: A row or column that displays subtotals for detail cells in a row or
column in a pivot table. The pivot table in the figure displays subtotals for
each branch.
Step1: Specifying the data location
The first dialog box presented by the PivotTable and PivotChart Wizard is shown
in Figure 9-5. In this step, you identify the data source. Excel is quite flexible in
the data that you can use for a pivot table. This example uses a worksheet database.
Figure 9-5: The first of three PivotTable and
PivotChart Wizard dialog boxes
You see different dialog boxes while you work through the wizard, depending
on the location of the data that you want to analyze. The following sections
present the wizard’s dialog boxes for data located in an Excel list or database.
Step 2: Specifying the data
To move on to the next step of the wizard, click the Next button. Step 2 of the
PivotTable and PivotChart Wizard prompts you for the data. Remember, the dialog
box varies depending on your choice in the first dialog box; Figure 9-6 shows the
dialog box that appears when you select an Excel list or database in Step 1.
Search JabSto ::

Custom Search