PivotCell.CustomSubtotalFunction Property
Definition
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 XlConsolidationFunctionProperty 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.