SortDirection Property

Microsoft Office Web Components Visual Basic

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)