The ASPxPivotGrid control represents data from the underlying data source in a cross-tabulated form. It calculates summaries and summary totals against specific fields and displays summary values within data cells. The following summary functions are supported: Sum, Average, Count, Min, Max, StdDev, StdDevp, StdVar, StdVarp.
A field is represented by the PivotGridField class. Two types of fields are supported: bound fields (which get their data from the data source) and unbound fields (which should be populated manually via the ASPxPivotGrid.CustomUnboundFieldData event).
For column fields, the control lists their values across the top edge. Similarly, row field values are listed across the control's left. Thus, a cell at the intersection of a column and row is identified by a column field value(s) and row field value(s). Obviously, multiple records in the control's data source can have identical values in the specified column field(s) and row field(s). Consequently, a cell in the ASPxPivotGrid control represents multiple records and displays a summary value calculated against these records. The summary is calculated against a data field, and the summary type is specified by the data field's PivotGridFieldBase.SummaryType property.