The FlexPivotPanel forms the core control available with FlexPivot.
The C1FlexPivotPanel control is designed to provide an Excel-like drag-and-drop UI that enables users to define custom views of the data. The control displays a list containing all the fields that exist in the data. Users can drag-and-drop these fields to lists that represent the row and column dimensions of the output table, the values summarized in the output data cells, and the fields used for filtering the data.
At the core of this control is a powerful data engine that is responsible for fetching raw data from the data source as per the criteria selected by the user. The criteria for data selection is determined by the fields enlisted in the various lists appearing on the panel.
FlexPivot features an open architecture. It can accept any regular collection as data, including tables and generic lists; and add LINQ enumerations to summarize the data and produce a regular data table as output.
The C1FlexPivotPanel control bound to a data source appears similar to the image below.
The following table describes the lists that are included in the C1FlexPivotPanel control and their purpose.
| C1FlexPivotPanel Area | Description |
| Filters | Specifies the field to filter. |
| Rows | The items added to the Rows list become the row headers of a grid. These items populate the Y-axis in a chart. |
| Columns | The items added to the Column list become the column headers of a grid. These items populate the legend in a chart. |
| Values | Shows the summation of the specified field. |
| Defer Updates | Suspends automatic updates that occur when the user modifies the view definition when this checkbox is selected. |
Upon right-clicking the Filter, Rows, Columns, or Values lists at runtime, a context menu appears that allows you to do the following.
- Move the field to a different area
- Remove the field
- Click field settings to format
- Apply a filter to the field
The image below illustrates the above stated options.
