Page 153 - Excel Data Analysis
P. 153
08 537547 Ch07.qxd 3/4/03 12:07 PM Page 139
WORKING WITH PIVOTTABLE REPORTS 7
After adding a calculated item, you can have If you have calculated items whose formulas rely on
Excel automatically sort the PivotTable report so another calculated item, you can make sure that
that it displays in ascending or descending order Excel calculates them in the right order by viewing
based upon the items in a particular field. To do how Excel solves the formulas. To do so, click
so, click PivotTable ➪ Sort and Top 10 on the PivotTable ➪ Formulas ➪ Solve Order. In the
PivotTable toolbar to display the PivotTable Sort Calculated Item Solve Order dialog box that
and Top 10 dialog box. The default AutoSort displays, click a formula and then click Move Up
option is manual, which means the report only or Move Down to change its order in the list.
sorts when you use the Data ➪ Sort option. To
sort it automatically, click either the Ascending or
Descending options ( changes to ), and
select the field to use for the sort. Click an
option in the Using field and select the
PivotTable report field with which you want to
sort. When you click OK, Excel sorts the
PivotTable using the specified sort key field. To
turn off the AutoSort, click the Manual option in
the PivotTable Sort and Top 10 dialog box.
Sales Type
■ The new calculated item ■ Repeat steps 3 to 5 to ■ The new calculated item
displays in the Items list box. create additional calculated displays in the PivotTable.
items for the selected field.
Á Click OK.
139
