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 Data |
Summary Type | The Summary |
Visibility | The Visible property. The pivot grid’s Options |
Cell Visibility | The Data |
Position | The Area and Area For data fields, the Area property is set to fa |
Appearance | For all field headers, the pivot grid’s Styles. To dynamically customize these style settings, handle the pivot grid’s Styles. 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 On |
Linking with Other Fields | The Group property. |
Context Menu | Refer to the Field Header Context Menu topic. |
Hints | The pivot grid’s Options The pivot grid’s On |
Hit | The Hit |