Microsoft Office Tutorials and References
In Depth Information
Lesson 15: Programming PivotTables
To create a PivotTable, complete the following steps:
1.
Drag the Item field name from the Choose Fields to Add to Report pane down to the Report
Filter pane.
2.
Drag the Region field name from the Choose Fields to Add to Report pane down to the Row
Labels pane.
3.
Drag the Store ID field name from the Choose Fields to Add to Report pane down to the
Row Labels pane, below the Region field name.
4.
Drag the When field name from the Choose Fields to Add to Report pane down to the
Column Labels pane.
5.
Drag the Revenue field name from the Choose Fields to Add to Report pane down to the
Values pane.
Your worksheet will look similar to Figure 15-5, with a PivotTable that shows the summary of
Revenue by Quarter for each Region, with each Region showing the detail of its stores’ activities.
The source list could have been more than a million rows deep, and the process would still have
only taken Excel a couple of moments to produce the PivotTable report.
figurE 15-5
Search JabSto ::




Custom Search