SurfaceValues (Property)

Applies To:

PivotSection object

Description:

Enables Pivots to perform calculations based on the computed item formula when a break total is evaluated. Changes to the property are selected in the user interface when the property is set. Changes to the user interface are reflected when the property is read. The default value of this property is false.

Average and Count aggregation Data Functions are not evaluated in True Total mode unless the Use Surface Values property is enabled. If disabled, the Average and Count aggregation are calculated using the count of the underlying Table/Result Section data values.

Action:

Read-write, Boolean

Example 1:

This example shows how to enable surface values:

//Surface Values ON
ActiveDocument.Sections["Pivot"].SurfaceValues=true

Example 2:

This example shows how to disable surface values:

//Surface Values OFF 
ActiveDocument.Sections["Pivot"].SurfaceValues=false