SortFunction (Property)

Applies To:

PivotLabels collection, XCategory object, ZCategory object

Description:

Returns or sets aggregate statistical functions. This property takes a BqSortFunction group value, which duplicates the data functions available in the Pivot and Chart sections. Use this property with SortByFact (Method) which enables you to sort by a numeric data item.

Action:

Read-only, String

Constants:

The BqSortFunction group constant has these values:

bqSortFunctionAverage
bySortFunctionCount
bqSortFunctionMaximum
bqSortFunctionMinimum
bqSortFunctionNonNullAverage
bqSortFunctionNonNullCount
bqSortFunctionNullCount
bqSortFunctionSum

Example

This example shows how to sort values based on the average statistical function:

ActiveDocument.Sections["Pivot3"].SideLabels["Product Name"].SortFunction= bqSortFunctionAverage