PivotField.AutoSortCustomSubtotal (Excel)

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

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.


Dim lngAutoSortCustomSubtotal As Long
lngAutoSortCustomSubtotal = ActiveCell.PivotField.AutoSortCustomSubtotal