Share via

RemoveTotal Method

  • Article

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.

Applies to | PivotDataAxis Object

See Also | AddTotal Method

Example

This example removes the Order Count total from the current view in PivotTable1.

PivotTable1.ActiveView.DataAxis.RemoveTotal "Order Count"