Example of Grouping Bar in Javascript Pivot Table Control

Grouping Bar

This sample demonstrates the grouping feature of the pivot table. The pivot fields are automatically populated from the bound data source, and they can be dragged and dropped to alter the report at runtime. The pivot fields can be sorted, filtered, added and removed dynamically as well.

More Details...


The pivot table grouping bar option automatically populates fields from the bound data source and allows end users to drag fields between different axes such as columns, rows, values, and filters, and create pivot table at runtime. To enable grouping bar, set the showGroupingBar property as true. Filter and sort icons allow displaying selective records and ordering them in ascending or descending order. The value type icon allows to display values based on selected aggregate type. The remove icon allows the user to remove the field from the report. During runtime, the Values button in the grouping bar can be moved to a different position (i.e., different index) among other fields in the column or row axis. To enable values button, set the showValuesButton property to true. The fields panel, which is located above the grouping bar, displays the fields that are available in the data source but are not bound in the report. The fields can be dragged and dropped into the appropriate axis. In addition, any field removed from any axes will be automatically added to the fields panel. The fields panel can be displayed by setting the showFieldsPanel property in the groupingBarSettings to true. Injecting Module: The pivot table features are segregated into individual modules. To take advantage of grouping bar support, we need to inject the GroupingBar module using the PivotView.Inject(GroupingBar) method. More information on the grouping bar can be found in this documentation section.