Back to Devexpress

Field Value

vcl-157084-expresspivotgrid-visual-elements-field-value.md

latest1.7 KB
Original Source

Field Value

  • Sep 06, 2024

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.