Edit

Share via


PivotCell.CustomSubtotalFunction Property

Definition

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

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