Establishes automatic field-sorting rules for PivotTable reports.
expression . AutoSort( Order , Field , PivotLine , CustomSubtotal )
expression A variable that represents a PivotField object.
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Order | Required | Long | One of the constants of XlSortOrder specifying the sort order. |
| Field | Required | String | The name of the sort key field. You must specify the unique name (as returned from the SourceName property), and not the displayed name. |
| PivotLine | Optional | Variant | A line on a column or row in a PivotTable report. |
| CustomSubtotal | Optional | Variant | The custom subtotal field. |
This example sorts the Company field in descending order, based on the sum of sales.
ActiveSheet.PivotTables(1).PivotField("Company") _
.AutoSort xlDescending, "Sum of Sales"