Share via


PivotField.Function Property

Returns or sets the function used to summarize the PivotTable field (data fields only). Read/write XlConsolidationFunction.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property Function As XlConsolidationFunction
    Get
    Set
'Usage
Dim instance As PivotField
Dim value As XlConsolidationFunction

value = instance.Function

instance.Function = value
XlConsolidationFunction Function { get; set; }

Property Value

Type: Microsoft.Office.Interop.Excel.XlConsolidationFunction

Remarks

For OLAP data sources, this property is read-only and always returns xlUnknown. For other data sources, this property cannot be set to xlUnknown.

See Also

Reference

PivotField Interface

PivotField Members

Microsoft.Office.Interop.Excel Namespace