Let's begin a basic Browse
process to illustrate the steps involved:
1.
Drag the Store Sales item
(a measure) from the PivotTable Field List to the Data section (the
portion of the PivotTable area with "Drop Data Items Here"
appearing in gray). A tiny icon appears in the image of the four-part map of
the PivotTable area. The "data" section of the icon image is blue,
indicating that the item we are dragging is a measure.
2.
Drop the Store Sales item
in the "Drop Data Items Here" (the "Data") section
of the PivotTable "map."
Illustration
13: The Store Sales Measure in the Data Section (PivotTable Field List Docked)
Most of the section
highlights disappear, as shown above, and the PivotTable report displays the Total
of Store Sales.
3.
Drag the Store dimension
to the row axis of the PivotTable report, where "Total"
appears at present for Store Sales (the icon that appears as we drag
will indicate the only allowed drop points, as the icon indicates when the dimension
is in "drop territory.").
The PivotTable report
now appears as shown below. We see Store Country has become the row
header label.
Illustration
14: The Store Dimension in the Row Axis
4.
Next, drag the Time
dimension to the column axis of the PivotTable report, where the empty
cell appears to the right of "Store Sales" and above "Total,"
as shown in Illustration 15. (Once again, the icon indicates when we
are in the correct position for dropping).
Illustration
15: The Time Dimension in the Column Axis
5.
Drag the Store Type
dimension to the page axis of the PivotTable report (the blue outlined
area at the top left corner of the worksheet, which probably still indicates "Drop
Page Fields Here"), as shown in Illustration 16.
Illustration
16: The Store Type Dimension in the Page Axis
Let's center the column headings to enhance the appearance of the
new report.
6.
Select and click Table
Options from the PivotTable menu on the PivotTable toolbar, as shown below.
Illustration
17: Selecting the Table Options Dialog
The PivotTable Options
dialog appears (as shown in Illustration 18). Many formatting and other
global setpoints appear here. We will click the Merge labels checkbox.
For information
regarding the purposes of the other setpoints, see the online Help and
other documentation.
Illustration
18: The PivotTable Options Dialog
7.
Click OK.
Compare the results set
to that shown below.
Illustration
19: Format Changes Appear in the PivotTable Report
We see that the labels are now centered.
» 
Comment and Contribute
