PivotColumnsSortOrderEnum Constants (ExPivot)

The PivotColumnsSortOrderEnum type specifies the way the columns are displayed. The PivotColumnsSortOrder property specifies the sorting order of the columns to be shown on the Columns Floating Panel ( PivotColumnsFloatBarVisible property ). The exPivotBarContextSortAscending, exPivotBarContextSortReverse flags of PivotBarVisible property specifies the sorting order of the columns to be shown on the pivot bar's context menu. The PivotColumnsSortOrderEnum type supports the following values:

Name	Value	Description
exPivotColumnsUnsorted	0	The columns are displayed the way they were loaded.
exPivotColumnsAscending	1	The columns are alphabetically displayed in ascending order.
exPivotColumnsDescending	2	The columns are alphabetically displayed in descending order.
exPivotColumnsReverse	3	The columns are displayed in reverse order.