FormatSettings

12 Sep 20251 minute to read

Allows specific fields used to display the values with specific format that used to be displayed in the pivot table.
For example, to display a specific field with currency formatted values in the pivot table, the set the format property to be C.

Properties

currency string

It allows to specify the currency code to be used for formatting.

format string

It allows to specify custom number format for formatting.

maximumFractionDigits number

It allows to specify maximum fraction digits to the formatted value.

maximumSignificantDigits number

It allows to specify maximum significant digits to the formatted value.

minimumFractionDigits number

It allows to specify minimum fraction digits to the formatted value.

minimumIntegerDigits number

It allows to specify minimum integer digits to the formatted value.

minimumSignificantDigits number

It allows to specify minimum significant digits to the formatted value.

name string

It allows to set the field name to apply format settings.

skeleton string

It allows to specify the skeleton such as full, medium, long, short, etc. to perform date formatting.

It is applicable only for date type formatting.

type string

It allows to specify the type of date formatting either date, dateTime or time.

useGrouping boolean

It allows to use grouping to the formatted value,

Defaults to true