TrueComputedItemTotals (Property)

Applies To:

PivotSection object

Description:

Recalculates all computed item break totals to equal to the sum (or other aggregation data function) of their displayed values in the Computed item column of the Pivot Section. To calculate break totals using the computed item formula, set the Boolean value to false in arguments.

When this property is false, the value in a computed item break totals is calculated based on the formula used to create the corresponding break total in the source fact column.

Average and Count aggregation Data Functions are not evaluated in True Total mode unless the SurfaceValues (Property) is also enabled. If the Surface Values (Property) is not enabled, the Average and Count aggregation are calculated using the count of the underlying Table/Result Section data values instead of the displayed Pivot values.

Action:

Read-write, Boolean

Example:

This example shows how to enable the true computed items totals option.

ActiveDocument.Sections["Pivot"].TrueComputedItemTotals = true