This guide gives a detailed overview of dxPivotGrid visual elements. Each topic in this guide contains a brief description of an element and its main features, which can be configured.
Below is a pivot grid element map. It may be helpful as you begin learning the capabilities of the dxPivotGrid widget. Hover over an element on the map to discover the name of this element. A click on an element navigates you to a topic devoted to this element.
Headers are used to annotate numeric values in the pivot grid. A column header consists of two parts — column area header (the header for Column Fields) and data area header (the header for Data Fields).
An area defines the type of field and the place where field data will be displayed: values of the 'row' and 'column' area fields are displayed in the headers, 'data' area contains fields whose numeric data will be used for calculating summary values. The 'filter' area is the pivot grid's third dimension — it does not have a visual representation, although fields of this area can be involved in a data selection process along with fields in the 'row' and 'column' areas.
Row and Column Areas
Fields that are put to the row, column and filter (which has no visual representation) areas are called dimensional fields. This type of field provides the categorical view of data. Several dimensional fields in a single area are organized as a hierarchy within a corresponding header. Each hierarchical level is defined by a dimensional field.
Dimension is a set of fields that describes a single entity from different sides or with different precision. For example, the dimension 'Time' can consist of the fields 'Year', 'Quarter', 'Month' and 'Day'; and the dimension 'Product' can contain fields 'Category', 'Subcategory' and 'Name'. In OLAP terminology, dimensional fields are called dimension attributes.
Since total summaries are a part of the pivot grid, they are also present in row and column headers.
Headers are strictly dependent on field configuration. Fields added to 'row' and 'column' areas will appear in the corresponding header. Field configuration can be changed in code or at runtime using the Field Chooser.
There is a number of options related to the context menu of headers:
Summary values are numbers, displayed in grid cells. In OLAP terminology, fields that are put to the data area are called measures and a single record (usually representing a business transaction) is called fact. Summary (measure) value is calculated by the aggregation of field values from a number of facts taken from the data source. The set of facts to be aggregated is different for each pivot grid cell and depends on three dimensional areas (row, column and filter). The aggregation method is configured using the summaryType option.
There is a number of options related to the display format that can be configured:
Total and Grand Total rows and columns are used to display summary values calculated in more general conditions than the conditions defined by the pivot grid's state. Each total row/column aggregates data of several pivot grid rows/columns in accordance with the summary type.
Total Rows or Columns
Total Rows and Total Columns display sub-totals calculated for outer row/column fields. For example, if you expand the UK group, you will see the rows characterizing cities and also a UK Total row. This row is equal to the collapsed UK row.
Grand Total Row and Column
Grand Total Rows and Grand Total Columns aggregate data of the entire pivot grid. They show values summarized across all available data.
The Field Chooser is a complementary widget integrated in the pivot grid that allows you to manage the displayed data. To invoke the Field Chooser, right-click the row or column header, and choose the "Show Field Chooser" option. Also, the Field Chooser can be invoked by clicking the top-left empty area of the pivot grid.
There is a number of Field Chooser options, which can be configured:
- enabled — enables or disables the field chooser;
- layout — specifies the field chooser layout;
- width, height — specifies the field chooser size;
- title — specifies the text to display as a title of the field chooser popup window.
Although the field chooser is already integrated in dxPivotGrid and can be invoked using the context menu, you can add it as a separate widget on your page. In this case, the field chooser will be displayed continuously and will not overlay the pivot grid.