PivotFieldSortSetting

PivotFieldSortSetting class

Represents the setting of sorting pivot fields.

class PivotFieldSortSetting;

Property	Type	Description
sortType	SortOrder	Readonly. Represents the SortOrder.
isSortByLabels	boolean	Readonly. Indicates whether sorting the field by itself or data field.
fieldIndex	number	Readonly. Represents the index of the field sorted by. -1 means sorting the PivotField by the labels,others means sorting by the data field.
lineTypeSortedBy	PivotLineType	Readonly. The pivot line type sorted by.
isSimpleSort	boolean	Readonly. Indicates whether a simple data sort operation will be applied.
cell	string	Readonly. Sorts by the values in which row or column.

Readonly. Represents the SortOrder.

sortType : SortOrder;

Readonly. Indicates whether sorting the field by itself or data field.

isSortByLabels : boolean;

Readonly. Represents the index of the field sorted by. -1 means sorting the PivotField by the labels,others means sorting by the data field.

fieldIndex : number;

Readonly. The pivot line type sorted by.

lineTypeSortedBy : PivotLineType;

Remarks

Only works when not sorting this field by labels.

Readonly. Indicates whether a simple data sort operation will be applied.

isSimpleSort : boolean;

Remarks

The default value is true.

Readonly. Sorts by the values in which row or column.

cell : string;