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.