Pivot Table / Formula / Aggregation

Blazor Pivot Table Example - Aggregation

Loading Syncfusion Blazor Server Demos…

Properties

This sample demonstrates aggregate types including sum, average, median, min, max, count, distinct count, and more for quick business analysis in the pivot table.

End users can change aggregation types for value fields at runtime using the field list dropdown. The aggregate type is set via the Type property in PivotViewValue.

Available built-in aggregates:

  • 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

Aggregate types can be changed dynamically via the field list UI using the dropdown icon.

For comprehensive aggregation documentation, refer to the documentation.

Transform your Blazor web apps today with Syncfusion® Blazor components
145+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE