Using Auto Sort to Control the Sort Order

The Excel user interface offers an AutoSort option that enables you to show customers in descending order based on revenue. It is possible to create pivot tables for years without ever finding this setting. In the Excel user interface, double-click the Customer button in the pivot report. This brings up the PivotTable Field dialog, as shown in Figure 12.12.

Figure 12.12

This dialog is the gateway to the AutoSort feature.

Figure 12.12

This dialog is the gateway to the AutoSort feature.

Pivottable Field Advanced Options

From the PivotTable Field dialog, click the Advanced button. Clicking this button opens the PivotTable Field Advanced Options dialog. Change the AutoSort option from Manual to Descending. When you select the Descending option, the drop-down for Using Field: appears. Change that drop-down to be Sum of Revenue. The dialog then looks like Figure 12.13.

0 0

Post a comment