RemoveTotal Method

Microsoft Office Web Components Object Model

RemoveTotal Method

       

Removes a total from the specified data axis.

expression.RemoveTotal(Total)

expression   An expression that returns a PivotDataAxis object.

Total   Required Variant. Specifies the total to be removed. Can be a PivotTotal object, a total’s name, or a total’s index number.

Example

This example removes the  Order Count total from the current view in PivotTable1.
PivotTable1.ActiveView.DataAxis.RemoveTotal "Order Count"