DevExpress.Xpf.PivotGrid Namespace
Contains classes which implement the main functionality of the DXPivotGrid Suite. To use these classes in XAML code, add the xmlns:dxpg=”http://schemas.devexpress.com/winfx/2008/xaml/pivotgrid“ namespace reference.
Assembly: DevExpress.Xpf.PivotGrid.v24.2.dll
NuGet Package: DevExpress.Wpf.PivotGrid
#Classes
Name | Description |
---|---|
Async |
The result of the asynchronous operation. |
Calculation |
The base class used to specify a Pivot |
Cell |
A Pivot Grid’s data cell to which the cell style is applied. |
Cell |
Contains the pivot grid’s cell data, location, and layout characteristics. |
Cell |
Stores information about the data cell displayed within the Pivot |
Color |
Represents a color scale format condition. |
Customize |
Contains data for the Pivot |
Custom |
Provides data for the Pivot |
Data |
The base class for the data area cells and field value cells. |
Data |
Contains the field value cell’s and data area cell’s data, location, and layout characteristics. |
Data |
Represents a data bar format condition. |
Data |
Base class of the the Data Binding API. Specifies the source data for the Pivot |
Data |
Defines a data binding to a data source column. |
Default |
Contains names of the context menu items. |
Difference |
Defines the difference calculation between values across a window. |
Directed |
Base class to specify calculations whose result is dependent on the direction of the calculation. Used as a Pivot |
Event |
A converter used to convert the event argument to the Cell |
Event |
A converter used to convert the event argument to the Field |
Expression |
Serves as a base for classes that represent expression-type format conditions. |
Expression |
Defines a calculation based on a string expression. |
Field |
Contains filter values for a specific field. |
Field |
Serves as the base class for a pivot grid’s Customization Controls. |
Field |
Represents a field value cell. |
Field |
A Pivot Grid field value cell to which the cell style is applied. |
Field |
Contains the pivot grid’s field value cell data, location, and layout characteristics. |
Field |
Stores information about the row and column fields related to the selected cell. |
Format |
Represents a format condition based on a specified rule |
Format |
Serves as a base for classes that represent format conditions. |
Format |
Represents a collection of format conditions. |
Format |
Contains parameters for conditional formatting commands. |
Group |
Provides data for the Pivot |
Group |
A group filter value. |
Group |
Represents a group filter condition. |
Group |
A collection of group filter values. |
Icon |
Represents an icon set format condition. |
Indicator |
Serves as a base for classes that represent indicator-type format conditions. |
Lightweight |
|
Lightweight |
|
Moving |
Defines aggregations across a specified number of values before and/or after the current value. |
Olap |
Allows you to use an expression to evaluate values for a Pivot Grid’s field in OLAP mode. |
Percent |
Allows you to calculate the input of all values in the window as a percentage of the total. |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the events which are invoked for particular data cells. |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
A row in the datasource passed to the chart control. |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Represents a single row in the data source which provides the data used to calculate summaries for individual cells. |
Pivot |
Represents a list of the records which are used to calculate summaries for individual cells. |
Pivot |
An Excel-style Field List. |
Pivot |
Provides data for the Expression |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for all field handling events. |
Pivot |
Provides data for the Pivot |
Pivot |
A simple-style Field List. |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Serves as a base for the classes that provide data for the events which are used to customize column and row headers. |
Pivot |
|
Pivot |
Provides access to pivot grid commands. |
Pivot |
The Pivot |
Pivot |
Contains options that define how a document is exported to CSV. |
Pivot |
Represents a custom total. |
Pivot |
Represents a collection of custom totals. |
Pivot |
Represents a Pivot Grid field. |
Pivot |
Represents a field collection for the Pivot |
Pivot |
|
Pivot |
|
Pivot |
Represents an individual group of fields. |
Pivot |
Represents a collection of field groups. |
Pivot |
Contains information about the field header context menu. |
Pivot |
|
Pivot |
Contains information about the context menu. |
Pivot |
A pop-up menu for the Pivot Grid. |
Pivot |
Contains export options specific to XLS format. |
Pivot |
Contains export options specific to XLS format. |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot event.
|
Pivot |
Contains the names of the OLAP measures that represent values of a particular KPI. |
Pivot |
Represents values of a KPI. |
Pivot |
An OLAP member. |
Pivot |
Provides data for the Pivot |
Pivot |
Provides data for the Pivot |
Pivot |
Contains options that control how the Pivot |
Pivot |
Represents a summary data source row. |
Pivot |
Represents a summary data source. |
Pivot |
Provides data for the Pivot |
Popup |
Provides data for the Pivot |
Rank |
Defines the calculation of a ranking in the window. |
Running |
Defines the calculation that aggregates values cumulatively in the window. |
Sort |
Represents a sort condition used to identify the column/row by whose values the other field values will be sorted. |
Sort |
A collection of sort conditions. |
Top |
Represents a top/bottom format condition. |
Window |
Specifies a custom string expression with window functions to calculate values. Used as a Pivot |
#Interfaces
Name | Description |
---|---|
IThread |
When implemented, provides a read-only access to basic settings of a field. |
#Delegates
#Enums
Name | Description |
---|---|
Allow |
Lists values that specify when fields can be hidden by end-users. |
Calculation |
Lists possible calculation directions in a table. |
Calculation |
Lists values used to specify a partition (frame) in a data table for window calculations. |
Copy |
Lists values that specify how to copy collapsed field values to the clipboard. |
Copy |
Lists values that specify how to copy cells to the clipboard when multiple cells are selected. |
Data |
Lists values that specify the area in which the data field headers are displayed. |
Data |
|
Data |
Lists values that specify an engine used to perform data processing (aggregation, summarization, etc.) in the pivot grid. |
Date |
Lists possible Date |
Difference |
|
Difference |
Lists the types of differences. |
Field |
Lists values that specify pivot grid areas where a field can be positioned. |
Field |
Lists the values that specify the areas where the pivot grid fields can be displayed. |
Field |
Lists the values used to specify which interface elements should be taken into account when calculating the optimal width for columns or rows. |
Field |
Lists values that specify the location of column totals. |
Field |
Contains the values that specify a field’s filter type in the Pivot |
Field |
Contains values that specify how the values of a specific column or row field are combined into groups. |
Field |
Lists values that specify which layouts can be applied to the Field List. |
Field |
Lists values that specify which fields the Customization Control should display. |
Field |
Lists values that specify the layout of the Field List. |
Field |
Lists values that specify how field headers should be arranged within the Customization Control. |
Field |
Lists values that specify the Field List‘s style. |
Field |
Lists values that specify whether to use the WHERE clause in an MDX query, when filtering against filter fields in OLAP mode. |
Field |
Lists values that identify properties of fields. |
Field |
Lists values that specify the location of row totals. |
Field |
Lists values that specify the sort order applied to a field when sorting by summaries is enabled for it. |
Field |
Lists values that specify a target UI element whose items are sorted. |
Field |
Lists the values that specify how a field’s data should be sorted. |
Field |
Lists the values that specify the sort order of a pivot grid’s fields. |
Field |
Contains options that specify how summary values are displayed within cells (“as is” or adjusted using a specific predefined algorithm). |
Field |
Lists values that specify the summary function types. |
Field |
Lists values that specify how the top n values for a specified data field are calculated. |
Field |
Lists the values that specify how the number of Top Values is determined. |
Field |
Contains values that specify which summary totals are displayed for a specific column field or row field. |
Field |
Contains values that specify the data type and binding mode of columns. |
Field |
Lists values that specify how the unbound expressions for a specified data field are calculated. |
Field |
Lists values that specify the types of column and row field values. |
Filter |
Lists styles of the filter drop-down to use for the current field. |
Group |
Lists values that specify what caused the field group to change. |
Group |
Lists values that specify the filtering mode for grouped fields. |
Olap |
Lists values that specify which data provider should be used when binding to an OLAP cube. |
Pivot |
Lists values that identify a brush type. |
Pivot |
Lists values that specify which data the pivot grid should pass to a bound chart control. |
Pivot |
Lists values that specify whether the pivot grid should pass columns or rows to a bound chart control when it is impossible to find the lowest-level data. |
Pivot |
Lists values that specify how the Pivot |
Pivot |
Lists values that specify how the Pivot |
Pivot |
Lists values that specify the type of a chart data member. |
Pivot |
Lists values that specify the type of a Pivot |
Pivot |
Lists values that specify for which fields the pivot grid processes only data related to their default members. |
Pivot |
Lists values that specify the pivot grid’s context menu types. |
Pivot |
Lists values that specify the graphic set used to indicate KPI values. |
Pivot |
Lists KPI types. |
Rank |
Lists rank types. |
Scrolling |
Lists values specifying the Pivot |
Select |
Lists values that specify the selection mode. |
Show |
Lists values that specify when the Pivot |
Store |
Lists options that specify which settings should be saved when saving the Pivot |
Summary |
|
Summary |
Lists options that specify the aggregation level for summary filtering. |
Unbound |
Lists values that specify how the unbound expressions for data fields are calculated. |
Use |
Lists values that specify whether to enable the lightweight templates feature. |
User |
Lists values that specify end-user actions on the Pivot |