RemoveTotal (Method)

Applies To:

OLAPLabels collection

Description:

Removes the totals rows added to a top or side label column.

Syntax:

Expression.RemoveTotal()

Example:

In this example, the totals row is removed from the side labels column of the OLAPQuery and the “Label Totals Have been Removed” alert message displays:

ActiveDocument.Sections["OLAPQuery"].SideLabels["State"].RemoveTotal()
Application.Alert("Label Totals Have been Removed")