• Material
  • Fabric
  • Bootstrap
  • Bootstrap v4
  • High Contrast
Theme Selection
Mode Selection


This sample demonstrates the aggregate types in the pivot table widget.


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 of the value field. The built-in aggregates are:

Sum, Average, 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.

To achieve aggregation through UI, navigate to "User Interaction > Field List" sample and click and open the value field settings menu to experience the same.