GroupingBarSettingsModel API in JavaScript (ES5) Pivot Table API control

Interface for a class GroupingBarSettings

Properties

allowDragAndDrop

boolean

Allows you to restrict the pivot buttons that were used to drag on runtime in the grouping bar UI. This will prevent you from modifying the current report.

By default, all fields are available for drag-and-drop operation in the grouping bar.

displayMode

View

Allow options to show the grouping bar UI to specific view port such as either pivot table or pivot chart or both table and chart. For example, to show the grouping bar UI to pivot table on its own, set the property displayMode to Table.

By default, the grouping bar UI will be shown to both pivot table as well as pivot chart.

showFieldsPanel

boolean

Allows you to show an additional UI along with the grouping bar UI, which contains the fields that aren’t bound in the current report. It allows you to modify the report by re-arranging the pivot buttons through drag-and-drop operation between axes (row, column, value and filter) that are used to update the pivot table during runtime.

This property is applicable only for relational data source.

showFilterIcon

boolean

Allows you to show or hide the filter icon that used to be displayed on the pivot button of the grouping bar UI. This filter icon is used to filter the members of a particular field at runtime in the pivot table.

By default, the filter icon is enabled in the grouping bar.

showRemoveIcon

boolean

Allows you to show or hide the remove icon that used to be displayed in the pivot button of the grouping bar UI. This remove icon is used to remove any field during runtime.

By default, the remove icon is enabled in the grouping bar.

showSortIcon

boolean

Allows you to show or hide the sort icon that used to be displayed in the pivot button of the grouping bar UI. This sort icon is used to order members of a particular fields either in ascending or descending at runtime.

By default, the sort icon is enabled in the grouping bar.

showValueTypeIcon

boolean

Allows you to show or hide the value type icon that used to be displayed in the pivot button of the grouping bar UI. This value type icon helps to select the appropriate aggregation type to value fields at runtime.

By default, the icon to set aggregate types is enabled in the grouping bar.