Field Location and Order
The Pivot Grid control has four areas where the data source fields can be located. These areas are: data, column, row and filter. Fields located within these areas are called data, column, row and filter fields, respectively. End-users can change a field’s location or order via drag-and-drop.
Contains data fields - the fields against which summaries are calculated. The summary results are displayed within the Data Area.
Contains column fields. The values of these fields are listed along the grid’s top edge and represent column headers.
Contains row fields. The values of these fields are listed along the grid’s left edge and represent row headers.
Contains filter fields, which allow end-users to apply filtering to the entire DXPivotGrid control.