Microsoft Office Tutorials and References
In Depth Information
Exhibit 5.6 Create PivotTable
Row Labels , and Values . Exhibit 5.8 shows the Row Labels area populated with
Gender . Of the four ﬁelds, the Page ﬁeld is the only one that is sometimes not
populated. Note that the Page ﬁeld provides a third dimension for the PivotTable .
5. Exhibit 5.9 shows the constructed table. I have selected Gender as the row,
Product 1 as the column, Region as the page, and Case as the values ﬁelds.
Additionally, I have selected count as the measure for Case in the data ﬁeld.
By selecting the pull down menu for the Values ﬁeld (see Exhibit 5.10) or by
right clicking a value in the table you can change the measure to one of many
possibilities— Sum , Count , Average , Min , Max , etc. Even greater ﬂexibility is
provided in the Show Values As menu tab. For example, the Value Field Settings
dialogue box allows you to select additional characteristics of how the count will
be presented—e.g. as a % of total Count . See Exhibit 5.11.
6. In Exhibit 5.12 you can see one of the extremely valuable features of PivotTables .
A pull-down menu is available for the Page , Row , and Column ﬁelds. These
correspond to Region , Gender , and Product 1 , respectively. These menus will