IField API in JavaScript Pivotfieldlist API control

Allows you to configure the information retrieved from the data source for the field list.

Properties

aggregateType

string

It allows to set the current aggregate type to the specific field.

allowDragAndDrop

boolean

It allows to enable/disable the drag and drop option to grouping bar and field list button.

baseField

string

It allows to set the selective field name to the field to perform aggregation.

baseItem

string

It allows to set the selective member of the specific field to perform aggregation.

caption

string

It allows to set the field caption.

dateMember

IAxisSet[]

It allows to set date members infomration of the specific field.

expandAll

boolean

Allows you to expand or collapse all of the pivot table’s headers for a specific field.

filter

string[]

It allows to set the current filter members to the specific field.

filterType

string

It allows to change the specific field’s type.

format

string

It allows to set the format to the specific field.

formatString

string

It allows to set the current number format string of the field.

formattedMembers

IMembers

It allows to set members caption infomration of the specific field.

formula

string

It allows to set the calculated field formula.

id

string

It allows to set the field name.

index

number

It allows to set the exact position of the specific field situated in the given data source.

isAlphanumeric

boolean

It allows you to check if the custom sort type of a specific field is Alphanumeric or not.

isCalculatedField

boolean

Allows to set whether is is a calculated field or not.

isCustomField

boolean

Allows to set wheather the specific field is custom grouped or not.

isExcelFilter

boolean

Allows to set the specific field for excel-like filtering.

isSelected

boolean

Allows to set whether the specific field is selected or not.

members

IMembers

It allows to set members infomration of the specific field.

membersOrder

string[] | number[]

It allows to set custom sort members of the specific field.

pid

string

It allows to set the parent name.

showEditIcon

boolean

It allows to set the visibility of calculated field edit icon in grouping bar and field list button.

showFilterIcon

boolean

It allows to set the visibility of filter icon in grouping bar and field list button.

showNoDataItems

boolean

Allows to set the specific field to display the data items that are not in combination with respect to current report.

showRemoveIcon

boolean

It allows to set the visibility of remove icon in grouping bar button.

showSortIcon

boolean

It allows to set the visibility of sort icon in grouping bar and field list button.

showSubTotals

boolean

It allows enable/disable sub total in pivot table.

showValueTypeIcon

boolean

It allows to set the visibility of summay type drop down icon in grouping bar and field list button.

sort

string

It allows to set the current sort order to the specific field.

type

string

It allows to set the field type to be either number or string or data or datetime.