Share via


PivotField.AutoSortCustomSubtotal Property (Excel)

Returns the name of the custom subtotal used to sort the specified PivotTable field automatically. Read-only.

Version Information

Version Added: Excel 2007

Syntax

expression .AutoSortCustomSubtotal

expression A variable that represents a PivotField object.

Remarks

The default value is 1 (Automatic). When the AutoSortCustomSubtotal property is set to 1 (Automatic), the data is sorted by the regular subtotals. The AutoSortCustomSubtotal property can have one of the index values listed in the following table.

1

Automatic

2

Sum

3

Count

4

Average

5

Max

6

Min

7

Product

8

Count Nums

9

StdDev

10

StdDevp

11

Var

12

Varp

Sorting is supported only by custom subtotals that are actually displayed in the PivotTable, so trying to set AutoSortCustomSubtotal to a value representing a custom subtotal not in the PivotTable view will return a run-time error.

If sorting is applied based on a custom subtotal, and that subtotal is removed from the PivotTable, the AutoSortCustomSubtotal property will automatically be set to the default value (1).

See Also

Concepts

PivotField Object

PivotField Object Members