ICalculatedFields API in JavaScript (ES5) Pivotfieldlist API control

Configures the specific calculated field information.

Properties

actualFormula

string

It allows to set the calculated field’s actual formula.

caption

string

It allows to set the caption to the calculated field that used to be displayed in the pivot table UI.

formatString

string

It allows to set format string that used to create calculated member with specified formatted values that to be displayed in the pivot table.

It is applicable only for OLAP data source.

formula

string

It allows to set the formula/expression to the specified calculated field.

hierarchyUniqueName

string

It allows to set hierarchy unique name, that used to create calculated member.

It is applicable only for OLAP data source.

name

string

It allows to set the field name that used to create as a calculated field.