PivotShowValuesSetting

PivotShowValuesSetting class

Represents the settings about showing values as when the ShowDataAs calculation is in use.

class PivotShowValuesSetting;

Methods

MethodDescription
getCalculationType()Represents how to show values of a data field in the pivot report.
setCalculationType(PivotFieldDataDisplayFormat)Represents how to show values of a data field in the pivot report.
getBaseFieldIndex()Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.
setBaseFieldIndex(number)Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.
getBaseItemPositionType()Represents type of the base pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields. Because PivotItemPosition.Custom is only for read,if you need to set PivotItemPosition.Custom, please set PivotField.BaseItemIndex attribute.
setBaseItemPositionType(PivotItemPositionType)Represents type of the base pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields. Because PivotItemPosition.Custom is only for read,if you need to set PivotItemPosition.Custom, please set PivotField.BaseItemIndex attribute.
getBaseItemIndex()Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields.
setBaseItemIndex(number)Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields.
isNull()Checks whether the implementation object is null.

getCalculationType()

Represents how to show values of a data field in the pivot report.

getCalculationType() : PivotFieldDataDisplayFormat;

Returns

PivotFieldDataDisplayFormat

setCalculationType(PivotFieldDataDisplayFormat)

Represents how to show values of a data field in the pivot report.

setCalculationType(value: PivotFieldDataDisplayFormat) : void;

Parameters:

ParameterTypeDescription
valuePivotFieldDataDisplayFormatThe value to set.

getBaseFieldIndex()

Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.

getBaseFieldIndex() : number;

setBaseFieldIndex(number)

Represents the base field for a ShowDataAs calculation when the ShowDataAs calculation is in use.

setBaseFieldIndex(value: number) : void;

Parameters:

ParameterTypeDescription
valuenumberThe value to set.

getBaseItemPositionType()

Represents type of the base pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields. Because PivotItemPosition.Custom is only for read,if you need to set PivotItemPosition.Custom, please set PivotField.BaseItemIndex attribute.

getBaseItemPositionType() : PivotItemPositionType;

Returns

PivotItemPositionType

setBaseItemPositionType(PivotItemPositionType)

Represents type of the base pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields. Because PivotItemPosition.Custom is only for read,if you need to set PivotItemPosition.Custom, please set PivotField.BaseItemIndex attribute.

setBaseItemPositionType(value: PivotItemPositionType) : void;

Parameters:

ParameterTypeDescription
valuePivotItemPositionTypeThe value to set.

getBaseItemIndex()

Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields.

getBaseItemIndex() : number;

setBaseItemIndex(number)

Represents the custom index of the pivot item in the base field when the ShowDataAs calculation is in use. Valid only for data fields.

setBaseItemIndex(value: number) : void;

Parameters:

ParameterTypeDescription
valuenumberThe value to set.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;