• Material 3
  • Fluent
  • Fluent2
  • Bootstrap v5
  • Tailwind CSS
  • High Contrast
Preferences
Mode Selection
Touch
Mouse
Theme Selection
Theme Mode
Localization
*Translated by Google Translator.
Currency

Example of Grouping Bar in ASP.NET Core Pivot Table Control

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.

DEMO
SOURCE

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 views 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 e-groupingBarSettings to true.

Transform your ASP.NET Core web apps today with Syncfusion ASP.NET Core components
85+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE
opens in a new tab