Function Property

Microsoft Office Web Components Object Model

Show All

Function Property

       

Returns or sets the function to be used for generating aggregate values. Read/write PivotTotalFunctionEnum.

PivotTotalFunctionEnum can be one of these PivotTotalFunctionEnum constants.
plFunctionAverage
plFunctionCalculated
plFunctionCount
plFunctionMax
plFunctionMin
plFunctionStdDev
plFunctionStdDevP
plFunctionSum
plFunctionUnknown
plFunctionVar
plFunctionVarP
 

expression.Function

expression   Required. An expression that returns a PivotTotal object.

Remarks

The Sum operator is the default value for numeric data types. The Count operator is the default value for other data types.