XlSortType Enumeration

Excel Developer Reference

Specifies which elements are to be sorted. Use this argument only when sorting PivotTable reports.

Name Value Description
xlSortLabels 2 Sorts the PivotTable report by labels.
xlSortValues 1 Sorts the PivotTable report by values.