Summary - Single Totals

The ASPxPivotGrid automatically calculates grand totals for each row and column. Additionally, totals are automatically calculated for each value group. The type of the automatic totals always matches the type of the summaries calculated in cells. Thus, automatic totals give you a more general data view while you still displaying the details. In this demo, you can use a number of view options to control the availability of totals.

Row Totals are rows that display sub-totals calculated for outer row fields. Column Totals are columns that display sub-totals calculated for outer column fields.

The ASPxPivotGrid control supports automatic and custom totals. Automatic totals are calculated using a summary function specified by a corresponding data field. Custom totals can be calculated using any summary function. It's possible to calculate multiple custom totals against a data field.