Microsoft Office Tutorials and References
In Depth Information
FIguRE 1-2 The standard PivotTable interface.
From here, you can choose to take, for example, the OrderYear and put it in columns and the
SalesPerson in the rows, and display the OrderSubTotal in the intersection of the rows and
columns. After properly formatting your numbers, you get a nice report (as you can see in
Figure 1-3) showing how salespeople performed over time.
FIguRE 1-3 Example of a report with the PivotTable tool.