Example of Aggregation in Javascript Pivot Table Control


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.

More Details...


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, 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. 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. More information on the aggregation can be found in this documentation section.