Search results

GroupingBarSettings API in Angular Pivot Grid API component

Allows a set of options for customizing the grouping bar UI with a variety of settings such as UI visibility to a specific view port, customizing the pivot button features such as filtering, sorting, changing aggregate types, removing any fields. The options available to customize the grouping bar UI are:

  • showFilterIcon: 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.
  • showSortIcon: 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.
  • showRemoveIcon: 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.
  • showValueTypeIcon: 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.
  • displayMode: 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.
  • allowDragAndDrop: 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.

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.

Defaults to true

displayMode

string

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.

Defaults to Both

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.

Defaults to true

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.

Defaults to true

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.

Defaults to true

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.

Defaults to true