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 fields, the Page field is the only one that is sometimes not
populated. Note that the Page field 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 fields.
Additionally, I have selected count as the measure for Case in the data field.
By selecting the pull down menu for the Values field (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 flexibility 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 fields. These
correspond to Region , Gender , and Product 1 , respectively. These menus will
Search JabSto ::




Custom Search