Totals Property

Microsoft Office Web Components Object Model

Totals Property

       

PivotDataAxis and PivotResultDataAxis objects: Returns a PivotTotals collection that contains all the PivotTotal objects on the summary axis. The totals are displayed in the summary area for each cell.

PivotView object: Returns a PivotTotals collection that contains all the totals in the current view.

expression.Totals

expression   Required. An expression that returns one of the objects in the Applies To list.