Data Field
- 2 minutes to read
Data fields are fields located in the pivot grid’s data header area. The ExpressPivotGrid calculates summaries against the data fields and the summary results are displayed within the data area. Refer to the TcxPivotGridSummaryType type description for details on available functions and the data field values they support.
The following image shows a sample ExpressPivotGrid control which contains a single “Payment Amount” data field.
When there are two or more data fields, the ExpressPivotGrid displays data field headers to distinguish between different summary values as shown in the image below.
By default, the data field headers are listed in the column area. To display the data field headers in the row area (along the control’s left edge), set the pivot grid’s OptionsDataField.Area property to faRow. The OptionsDataField.AreaIndex property specifies the position of the data field headers within the hierarchy of field values.
Setting the OptionsDataField.Area property to faCoumn or faRow enables the data field anchor. This field is linked with all the visible data fields. It can be dragged to a specific position within the column header area or row header area thus moving the data field headers to the specified location.
The table below lists the main properties which affect a data field’s appearance and behavior.
Binding Settings | The DataBinding property. |
Summary Type | The SummaryType property. |
Visibility | The Visible property. The pivot grid’s OptionsView.DataFields property. |
Cell Visibility | The DataVisibility property. |
Position | The Area and AreaIndex properties. For data fields, the Area property is set to faData. |
Appearance | For all field headers, the pivot grid’s Styles.FieldHeader property. To dynamically customize these style settings, handle the pivot grid’s Styles.OnGetFieldHeaderStyle events. Note These style settings do not modify an element’s background if the pivot grid is painted using the Windows XP (native) or Office2003 style. |
Custom Draw Event | The OnCustomDrawFieldHeader event. |
Linking with Other Fields | The Group property. |
Context Menu | Refer to the Field Header Context Menu topic. |
Hints | The pivot grid’s OptionsBehavior.FieldHeaderHints property. The pivot grid’s OnGetCellHint event. |
HitTest Information | The HitTest.HitAtField property. |