15.
Click the Captions tab.
16.
Change the caption to read Sr
Manager.
17.
Make the Font Arial,
Bold and Indigo.
The Commands and
Options dialog - Captions tab appears, with our changes, as shown in
Illustration 21.
Illustration 21: The
Commands and Options Dialog - Captions Tab
18.
Close the Commands and
Options dialog, leaving all other setpoints as before.
The result set in the PivotTable
List should resemble that shown in Illustration 22.
Illustration 22: The
Pivot Table List - After Formatting Modifications
Formatting virtually
any PivotTable List component is just this simple. We simply need to remember that
changing formats for any member of a group (in our case, labels) changes
all members of the group simultaneously.
19.
Click the Pivot Table Field
List toolbar button to display the PivotTable Field List.
20.
Drag the Employee Salary
measure (under Totals in the tree) to the Total or Detail fields
drop area, dropping it to the immediate right of the Count measure
label.
21.
Right-click the Employee
Salary label and select Commands and Options from the context menu.
The Commands and
Options dialog appears for the Employee Salary measure.
22.
Change the caption (Captions
tab) to read Salary (000), to make the Employee Salary measure perhaps
a bit more meaningful to anyone reviewing the PivotTable List.
23.
Select Currency
as the Number format (Format tab).
24.
Close the Commands and
Options dialog.
25.
Save the PivotTable List by
clicking the Save button on the top toolbar, or by choosing File -`
Save.
26.
Click to the left side of the
PivotTable List, causing the cursor to flash on its left.
27.
Press Enter to move the
PivotTable List down.
28.
Click in the space above the
PivotTable List.
29.
Type the following text:
Headcount
and Salary: Location, Department and Employees
30.
Format to taste.
(I used Verdana
18-pt Bold, and aligned the title and PivotTable List with the Center
button in the FrontPage toolbar.)
31.
Save the PivotTable List,
leaving it open for the remainder of the lesson.
NOTE: Always remember to save any time changes are
made in design mode, to ensure that the changes are retained.
32.
Click the Preview tab to
see a PivotTable List that should resemble (in all material respects) the one
shown in Illustration 23.
Illustration 23: The
Pivot Table List - Final View
The majority of the
browser functionality that is available to information consumers from our newly
designed PivotTable List is based upon our saved efforts from the design
mode. We will see even more how this is true in the following section.
Far more innovation can
be undertaken with the PivotTable List, and there are many more nuances to
explore. I hope that the exercises above will serve as a good navigational
introduction, and as a jumpstart to further exploration.
Let's conclude this
lesson with a final discussion surrounding how to make functionality available
to information consumers, and how to restrict what they can accomplish
within the scope of the PivotTable List design.
» 
Comment and Contribute
