PivotCell.CustomSubtotalFunction Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns the custom subtotal function field setting of a PivotCell object.

public:
 property Microsoft::Office::Interop::Excel::XlConsolidationFunction CustomSubtotalFunction { Microsoft::Office::Interop::Excel::XlConsolidationFunction get(); };

public Microsoft.Office.Interop.Excel.XlConsolidationFunction CustomSubtotalFunction { get; }

Public ReadOnly Property CustomSubtotalFunction As XlConsolidationFunction

Property Value

XlConsolidationFunction

Remarks

XlConsolidationFunction can be one of the following XlConsolidationFunction constants:

xlAverage

xlCount

xlCountNums

xlMax

xlMin

xlProduct

xlStDev

xlStDevP

xlSum

xlUnknown

xlVar

xlVarP

The CustomSubtotalFunction property will return an error if the PivotCell object type is not a custom subtotal. This property applies only to non-OLAP source data.

Applies to