PivotField.Subtotals[Object] 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 or sets subtotals displayed with the specified field. Valid only for non-data fields. Read/write Object.

public:
 property System::Object ^ Subtotals[System::Object ^] { System::Object ^ get(System::Object ^ Index); void set(System::Object ^ Index, System::Object ^ value); };

public object Subtotals[object Index] { get; set; }

Public Property Subtotals(Optional Index As Object) As Object

Parameters

Index: Object

Optional Object. A subtotal index, as shown in the following table. If this argument is omitted, the Subtotals method returns an array that contains a Boolean value for each subtotal.IndexMeaning1Automatic2Sum3Count4Average5Max6Min7Product8Count Nums9StdDev10StdDevp11Var12VarpIf an index is True, the field shows that subtotal. If index 1 (Automatic) is True, all other values are set to False.

Property Value

Object

Remarks

For OLAP data sources, Index can only return or be set to 1 (Automatic). The returned array always contains True or False for the first array element, and it contains False for all other elements. An array of element values that are all False indicates that there are no subtotals.

Applies to