Excel.ShowAsRule interface

Package:

excel

Remarks

[Api set: ExcelApi 1.8]

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 Excel.ShowAsCalculation for details.

Property Details

baseField

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

baseField?: Excel.PivotField;

Property Value

Excel.PivotField

Remarks

[Api set: ExcelApi 1.8]

baseItem

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

baseItem?: Excel.PivotItem;

Property Value

Excel.PivotItem

Remarks

[Api set: ExcelApi 1.8]

calculation

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

calculation: Excel.ShowAsCalculation | "Unknown" | "None" | "PercentOfGrandTotal" | "PercentOfRowTotal" | "PercentOfColumnTotal" | "PercentOfParentRowTotal" | "PercentOfParentColumnTotal" | "PercentOfParentTotal" | "PercentOf" | "RunningTotal" | "PercentRunningTotal" | "DifferenceFrom" | "PercentDifferenceFrom" | "RankAscending" | "RankDecending" | "Index";

Property Value

Excel.ShowAsCalculation | "Unknown" | "None" | "PercentOfGrandTotal" | "PercentOfRowTotal" | "PercentOfColumnTotal" | "PercentOfParentRowTotal" | "PercentOfParentColumnTotal" | "PercentOfParentTotal" | "PercentOf" | "RunningTotal" | "PercentRunningTotal" | "DifferenceFrom" | "PercentDifferenceFrom" | "RankAscending" | "RankDecending" | "Index"

Remarks

[Api set: ExcelApi 1.8]