The Pivot Options tab allows you to enable and disable surface values, how to handle true computed item totals, and how to treat null fact values.
| Option | Description |
|---|---|
| Use Surface Values | Recalculates the values in the visible cells or surface of the pivot rather than the values in the Results section |
| True Computed Item Totals | Recalculates break totals so that each total value is equal to the sum of their displayed detail cells. True computed item totals use aggregation according to the specified data function and does not rely on the computed item total formula. If you disable this option, the break total cell values are derived from the computed item formula applied to the detail cell. Average and Count aggregation Data Functions are not evaluated in True Total mode unless you enable Use Surface Values. If you do not enable Use Surface Values, the Average and Count aggregation are calculated using the count of the underlying Table/Result section data values instead of the displayed Pivot values. |
| Enable Null Facts In Computed Items | Evaluates a null fact value (an empty cell value) as a zero fact value for non-Moving functions. For Moving Function calculations, where the presence of all displayed Fact cell must be considered in calculations, the following behavior occurs when null fact values are considered as zero. The default option to evaluate and show null values is disabled. |