Field Value
The values of fields (also called field values) are the basis of the various reports that can be built using the ExpressPivotGrid. Field values provide data for the following purposes:
Filtering. The values of filter fields can be used to apply filter to the entire control to display data for specific values only.
Layout. The values of column fields and row fields are used to categorize data and represent the results in a tabular form. Categories can be arranged by sorting either the corresponding field values or summary values (via the “sorting by summary“ feature).
Calculation. The values of data fields are used to calculate summaries in each category using a number of summary functions. Summary values are displayed in the data area. Each data cell displays a summary calculated for a subset of records in the control’s underlying data source. All records from this subset have matching values in a column field(s) and row field(s), and these values are identified by column and row headers.
Unique column and row field values represent grouping values for columns and rows.
