Microsoft Office Tutorials and References
In Depth Information
Figure 20-4. Step 4 in the PivotTable wizard
This dialog is where we format the PivotTable by deciding which columns of the original source
table become pages in the PivotTable, which become rows, which become columns, and which
become data (for aggregation). The procedure is to drag the buttons on the right to the proper
location—row, column, page, or data. (We want one page for each of the two years.)
For our example, we drag the buttons to the locations shown in Figure 20-4 . Note that the only
button not used is Store Code. This field is the aggregate field, that is, we will sum over all store
codes.
Figure 20-4. Step 4 in the PivotTable wizard
Clicking the Next button takes us to the dialog in Figure 20-5 , where we choose the location for
the PivotTable. We choose a new worksheet.
Figure 20-5. Step 5 in the PivotTable wizard
Clicking the Finish button produces the PivotTable in Figure 20-6 .
Figure 20-6. The PivotTable
 
 
 
 
 
Search JabSto ::




Custom Search