CalculatedFieldSettings API in React Pivot Table API component

Allows options to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table.

Properties

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.