ExcelScript.ShowAsRule interface

Properties

baseField

The PivotField to base the ShowAs calculation on, if applicable according to the ShowAsCalculation type, else null.

baseItem

The item to base the ShowAs calculation on, if applicable according to the ShowAsCalculation type, else null.

calculation

The ShowAs calculation to use for the PivotField. See ExcelScript.ShowAsCalculation for details.

Property Details

baseField

The PivotField to base the ShowAs calculation on, if applicable according to the ShowAsCalculation type, else null.

baseField?: PivotField;

Property Value

baseItem

The item to base the ShowAs calculation on, if applicable according to the ShowAsCalculation type, else null.

baseItem?: PivotItem;

Property Value

calculation

The ShowAs calculation to use for the PivotField. See ExcelScript.ShowAsCalculation for details.

calculation: ShowAsCalculation;

Property Value