DataSource

Configures the settings of dataSource.

Properties

allowLabelFilter

boolean

It allows excel-like label filtering operation.

Defaults to false

allowValueFilter

boolean

It allows excel-like value filtering operation.

Defaults to false

alwaysShowValueHeader

boolean

It allows enable/disable single measure headers in pivot table.

Defaults to false

calculatedFieldSettings

CalculatedFieldSettingsModel[]

It allows to set the settings of calculated field operation.

Defaults to []

columns

FieldOptionsModel[]

It allows to set the column fields.

Defaults to []

conditionalFormatSettings

ConditionalFormatSettingsModel[]

It allows to set the settings of Conditional Format operation.

Defaults to []

data

IDataSet[] | DataManager

It allows to set the data source.

drilledMembers

DrillOptionsModel[]

It allows to set the drilled state for desired field members.

Defaults to []

emptyCellsTextContent

string

It allows to set the custom values to empty value cells .

enableSorting

boolean

It allows sorting operation UI.

Defaults to true

excludeFields

string[]

It allows to hide fields from fieldlist.

Defaults to []

expandAll

boolean

It allows to set the expanded state of headers.

Defaults to false

filterSettings

FilterModel[]

It allows to set the settings of filtering operation.

Defaults to []

filters

FieldOptionsModel[]

It allows to set the filter fields.

Defaults to []

formatSettings

FormatSettingsModel[]

It allows to set the settings of number formatting.

Defaults to []

groupSettings

GroupSettingsModel[]

It allows to set the settings for grouping the date.

Defaults to []

rows

FieldOptionsModel[]

It allows to set the row fields.

Defaults to []

showAggregationOnValueField

boolean

It allows enable/disable show aggregation on PivotButton.

Defaults to true

showColumnGrandTotals

boolean

It allows enable/disable column grand total in pivot table.

Defaults to true

showColumnSubTotals

boolean

It allows enable/disable column sub total in pivot table.

Defaults to true

showGrandTotals

boolean

It allows enable/disable grand total in pivot table.

Defaults to true

showRowGrandTotals

boolean

It allows enable/disable row grand total in pivot table.

Defaults to true

showRowSubTotals

boolean

It allows enable/disable row sub total in pivot table.

Defaults to true

showSubTotals

boolean

It allows enable/disable sub total in pivot table.

Defaults to true

sortSettings

SortModel[]

It allows to set the settings of sorting operation.

Defaults to []

valueAxis

string

It allows to set the value fields in both column and row axis.

Defaults to ‘column’

valueSortSettings

ValueSortSettingsModel

It allows to set the settings of value sorting operation.

values

FieldOptionsModel[]

It allows to set the value fields.

Defaults to []