Example of Aggregation in Blazor Pivot Table Component
This sample demonstrates the aggregate types like sum, average, median, min, max, count, distinct count, and more in the pivot table for quick business analysis. End users can also change the aggregation type of each field bound to the value axis in the field list at runtime.
Grand Total |
|---|
| Grand Total | No records to display |
Properties
In this sample, you can change the aggregate types for value fields using the dropdown list separately. The
aggregate type can be set using the Type property in PivotViewValue. The built-in aggregates are:
Sum, Average, Median, Min, Max, Count,
Distinct Count, Product,
Index, Population StDev, Sample StDev, Population Var,
Sample Var, Running Totals,
Difference From, % of Difference From, % of Grand Total,
% of Column Total, % of Row Total,
% of Parent Total, % of Parent Column Total, % of Parent Row Total.
In this sample, you can also change the aggregate type for value fields at runtime using the dropdown icon via field list UI.
More information on the aggregation feature can be found in this documentation section.