Microsoft Office Tutorials and References
In Depth Information
Chapter 26: Pivot Tables
FIGURE 26.1 Simple Database Used in a PivotTable
FIGURE 26.2 For the PivotTable, Click on the PivotTable Icon under the Insert Ribbon
Before you start using pivot tables you may want to make them look and
more
importantly
feel like the classic pivot table that enables you to drag and drop
the fields into the table. This has to be done only once. Right-click anywhere in the
PivotTable area, and choose the classic layout in the PivotTable options. See Figure
26.4.
After you change the layout to the classic layout and move the parameter list
closer to the pivot table, your Excel screen will resemble Figure 26.5.
To create the PivotTable, you want to have one parameter, say Job, on the left as
Row Labels and the other parameter, maybe Gender, as Column Labels on the top.
The PivotTable report will have four areas as shown in Figure 26.6:
1. The Report filter will be on top of the report. This is the area you use to filter the
complete data.
2. The Row Labels is the Field where you move fields you want on the horizontal
part of the table.
3. The Column Labels is the Filed where you move fields you want on the vertical
part of the table.
4. The center,
Σ
Values area is where your data will be summarized.
Search JabSto ::




Custom Search