RemoveTotal Method

Microsoft Office Web Components Visual Basic

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"