Configures the settings of dataSource.
boolean
It allows excel-like label filtering operation.
Defaults to false
boolean
It allows excel-like value filtering operation.
Defaults to false
boolean
It allows enable/disable single measure headers in pivot table.
Defaults to false
CalculatedFieldSettingsModel[]
It allows to set the settings of calculated field operation.
Defaults to []
It allows to set the column fields.
Defaults to []
ConditionalFormatSettingsModel[]
It allows to set the settings of Conditional Format operation.
Defaults to []
IDataSet[]
| DataManager
It allows to set the data source.
It allows to set the drilled state for desired field members.
Defaults to []
string
It allows to set the custom values to empty value cells .
boolean
It allows sorting operation UI.
Defaults to true
string[]
It allows to hide fields from fieldlist.
Defaults to []
boolean
It allows to set the expanded state of headers.
Defaults to false
It allows to set the settings of filtering operation.
Defaults to []
It allows to set the filter fields.
Defaults to []
It allows to set the settings of number formatting.
Defaults to []
It allows to set the settings for grouping the date.
Defaults to []
It allows to set the row fields.
Defaults to []
boolean
It allows enable/disable show aggregation on PivotButton.
Defaults to true
boolean
It allows enable/disable column grand total in pivot table.
Defaults to true
boolean
It allows enable/disable column sub total in pivot table.
Defaults to true
boolean
It allows enable/disable grand total in pivot table.
Defaults to true
boolean
It allows enable/disable row grand total in pivot table.
Defaults to true
boolean
It allows enable/disable row sub total in pivot table.
Defaults to true
boolean
It allows enable/disable sub total in pivot table.
Defaults to true
It allows to set the settings of sorting operation.
Defaults to []
string
It allows to set the value fields in both column and row axis.
Defaults to ‘column’
It allows to set the settings of value sorting operation.
It allows to set the value fields.
Defaults to []