Blazor Pivot Table Example - Grouping
This sample demonstrates grouping dates in year, quarter, month, etc., and number types in ranges like 1-4, 5-8,etc. in row and column headers of the pivot table.
Properties
Group Date by
|
Group Product ID by
|
In this sample, the date type can be separated and showcased individually as year, quarter, month, or day by selecting the appropriate option from the Group Date by drop-down list. Also, numbers can be grouped by entering the appropriate value in the Group Product ID by giving a range number in the the numeric text box.
Grouping can be applied through code-behind using the PivotViewGroupSetting in the pivot table along with the following properties:
Name |
: Specifies the normal field. |
Type |
: Specifies the field type for applying the group settings. For example, date formatted fields should be in Date type and number formatted fields should be in Number type. |
GroupInterval |
: Specifies the interval for date fields in years, quarters, months, etc. |
RangeInterval |
: Specifies the interval value to group the number field. |
More information on the grouping feature can be found in this documentation section.