Pin Me

Microsoft Excel: Present A Pivot Table In High-To-Low Order By Revenue

written by: Mr Excel•edited by: Tricia Goss•updated: 11/18/2011

Problem: A Pivot Table organizes data alphabetically by default, as shown in Fig. 892. You want to produce a report sorted high-to-low by Revenue.

  • slide 1 of 2

    Strategy: Each pivot field offers a sort option. To access the Sort options for the pivot field, follow these steps.

    1) As shown in Fig. 893, doubleclick the Customer field in the pivot table.

    2) This brings up the PivotTable Field dialog. Choose the Advanced button on the right side, as shown in Fig. 894.

    3) As shown the PivotTable Field Advanced Options dialog in Fig. 895, you can see that the default sort is Manual. This option lets you resequence items by dragging or retyping. In the current example, you want to choose Descending.

    4) Use the dropdown in the Using Field: area to choose to order by Sum of Revenue, as shown in Fig. 896.

    Result: The report is sequenced with the largest customers at the top, as shown in Fig. 897.

    Summary: The AutoSort options are fairly well hidden, but offer a variety of sorting options for each field in a pivot table.

  • slide 2 of 2

    Images

    Fig. 892Fig. 893Fig. 894Fig. 895Fig. 896Fig. 897