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, and removed dynamically as well.
|
|
|
|
|
|
|
|
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. 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.