SortDirection Property

PivotFieldSortDirectionEnum

PivotFieldSortDirectionEnum can be one of these PivotFieldSortDirectionEnum constants.
plSortDirectionAscending
plSortDirectionCustom
plSortDirectionCustomAscending
plSortDirectionCustomDescending
plSortDirectionDefault
plSortDirectionDescending

expression.SortDirection

*expression   * Required. An expression that returns a PivotField object.

Remarks

The field is sorted based on the sorting rules of the underlying data provider. For example, a data provider might sort dates alphanumerically (February, January, and so on) or in a chronological monthly sequence (January, February, and so on)

Applies to | PivotField Object

See Also | SortOn Property | SortOnScope Property