Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
 [Expand]DevExpress ORM Tool
 [Expand]DevExpress Data Library
 [Expand]Miscellaneous
 [Collapse]API Reference
  [Expand]DevExpress.Data
  [Expand]DevExpress.Data.Browsing
  [Expand]DevExpress.Data.Browsing.Design
  [Expand]DevExpress.Data.Camera
  [Expand]DevExpress.Data.Controls
  [Expand]DevExpress.Data.Controls.ExpressionEditor
  [Expand]DevExpress.Data.Entity
  [Expand]DevExpress.Data.Filtering
  [Expand]DevExpress.Data.Filtering.Exceptions
  [Expand]DevExpress.Data.Filtering.Helpers
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Data.ODataLinq
  [Expand]DevExpress.Data.PivotGrid
  [Expand]DevExpress.Data.PLinq
  [Expand]DevExpress.Data.TreeList
  [Expand]DevExpress.Data.Utils
  [Expand]DevExpress.Data.Utils.ServiceModel
  [Expand]DevExpress.Data.WcfLinq
  [Expand]DevExpress.Data.WizardFramework
  [Expand]DevExpress.Data.XtraReports.DataProviders
  [Expand]DevExpress.Data.XtraReports.Labels
  [Expand]DevExpress.Data.XtraReports.ServiceModel
  [Expand]DevExpress.Data.XtraReports.ServiceModel.DataContracts
  [Expand]DevExpress.Data.XtraReports.Wizard
  [Expand]DevExpress.Data.XtraReports.Wizard.Presenters
  [Expand]DevExpress.Data.XtraReports.Wizard.Views
  [Expand]DevExpress.DataAccess
  [Expand]DevExpress.DataAccess.ConnectionParameters
  [Expand]DevExpress.DataAccess.EntityFramework
  [Expand]DevExpress.DataAccess.Excel
  [Expand]DevExpress.DataAccess.ExpressionEditor
  [Expand]DevExpress.DataAccess.Localization
  [Expand]DevExpress.DataAccess.ObjectBinding
  [Expand]DevExpress.DataAccess.Sql
  [Expand]DevExpress.DataAccess.Sql.DataApi
  [Expand]DevExpress.DataAccess.UI.Design
  [Expand]DevExpress.DataAccess.UI.EntityFramework
  [Expand]DevExpress.DataAccess.UI.Excel
  [Expand]DevExpress.DataAccess.UI.Localization
  [Expand]DevExpress.DataAccess.UI.ObjectBinding
  [Expand]DevExpress.DataAccess.UI.Sql
  [Expand]DevExpress.DataAccess.UI.Wizard
  [Expand]DevExpress.DataAccess.UI.Wizard.Services
  [Expand]DevExpress.DataAccess.UI.Wizard.Views
  [Expand]DevExpress.DataAccess.Web
  [Expand]DevExpress.DataAccess.Wizard
  [Expand]DevExpress.DataAccess.Wizard.Model
  [Expand]DevExpress.DataAccess.Wizard.Presenters
  [Expand]DevExpress.DataAccess.Wizard.Services
  [Expand]DevExpress.DataAccess.Wizard.Views
  [Expand]DevExpress.Diagram.Core
  [Expand]DevExpress.Diagram.Core.Layout
  [Expand]DevExpress.Diagram.Core.Localization
  [Expand]DevExpress.Diagram.Core.Shapes
  [Expand]DevExpress.Diagram.Core.Themes
  [Expand]DevExpress.DocumentServices.ServiceModel
  [Expand]DevExpress.DocumentServices.ServiceModel.Client
  [Expand]DevExpress.DocumentServices.ServiceModel.DataContracts
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.Entity.Model
  [Expand]DevExpress.Entity.ProjectModel
  [Expand]DevExpress.Export
  [Expand]DevExpress.Export.Xl
  [Expand]DevExpress.Map
  [Expand]DevExpress.Mvvm
  [Expand]DevExpress.Mvvm.DataAnnotations
  [Expand]DevExpress.Mvvm.DataModel
  [Expand]DevExpress.Mvvm.ModuleInjection
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.Utils
  [Expand]DevExpress.Mvvm.ViewModel
  [Expand]DevExpress.Office
  [Expand]DevExpress.Office.Crypto
  [Expand]DevExpress.Office.Drawing
  [Expand]DevExpress.Office.Export
  [Expand]DevExpress.Office.Export.Html
  [Expand]DevExpress.Office.Import
  [Expand]DevExpress.Office.Localization
  [Expand]DevExpress.Office.Options
  [Expand]DevExpress.Office.Services
  [Expand]DevExpress.Office.Utils
  [Expand]DevExpress.Pdf
  [Expand]DevExpress.Pdf.Localization
  [Expand]DevExpress.PivotGrid.Printing
  [Expand]DevExpress.Printing
  [Expand]DevExpress.Printing.Core
  [Expand]DevExpress.ReportServer.Printing
  [Expand]DevExpress.ReportServer.Printing.Services
  [Expand]DevExpress.ReportServer.ServiceModel.Client
  [Expand]DevExpress.ReportServer.ServiceModel.ConnectionProviders
  [Expand]DevExpress.ReportServer.ServiceModel.DataContracts
  [Expand]DevExpress.Schedule
  [Expand]DevExpress.Services
  [Expand]DevExpress.Sparkline
  [Expand]DevExpress.Spreadsheet
  [Expand]DevExpress.Spreadsheet.Charts
  [Expand]DevExpress.Spreadsheet.Drawings
  [Expand]DevExpress.Spreadsheet.Export
  [Expand]DevExpress.Spreadsheet.Formulas
  [Expand]DevExpress.Spreadsheet.Functions
  [Expand]DevExpress.TreeMap
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Commands
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.Filtering.Internal
  [Expand]DevExpress.Utils.IoC
  [Expand]DevExpress.Utils.Localization
  [Expand]DevExpress.Utils.Serializing.Helpers
  [Expand]DevExpress.WebUtils
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpo
  [Expand]DevExpress.Xpo.DB
  [Expand]DevExpress.Xpo.DB.Exceptions
  [Expand]DevExpress.Xpo.DB.Helpers
  [Expand]DevExpress.Xpo.Exceptions
  [Expand]DevExpress.Xpo.Helpers
  [Expand]DevExpress.Xpo.Metadata
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Localization
  [Expand]DevExpress.XtraCharts.Printing
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraExport.Csv
  [Expand]DevExpress.XtraGauges.Base
  [Expand]DevExpress.XtraGauges.Core
  [Expand]DevExpress.XtraGauges.Core.Base
  [Expand]DevExpress.XtraGauges.Core.Drawing
  [Expand]DevExpress.XtraGauges.Core.Localization
  [Expand]DevExpress.XtraGauges.Core.Model
  [Expand]DevExpress.XtraGauges.Core.Primitive
  [Expand]DevExpress.XtraGrid
  [Collapse]DevExpress.XtraPivotGrid
    AdomdVersion Enumeration
    AllowHideFieldsType Enumeration
    AsyncCompletedHandler Delegate
   [Expand]AsyncOperationResult Class
   [Expand]BaseFilter Class
    CopyCollapsedValuesMode Enumeration
    CopyMultiSelectionMode Enumeration
   [Expand]CrossAreaKey Class
   [Expand]CustomCustomizationFormSortEventArgsBase<T> Class
   [Expand]CustomFieldDataEventArgsBase<T> Class
   [Expand]CustomServerModeSortEventArgsBase<T> Class
    DataFieldUnboundExpressionMode Enumeration
    ExportCellType Enumeration
   [Expand]FieldValueCellBase<T> Class
   [Expand]IOLAPMember Interface
   [Expand]IPivotCustomSummaryValue Interface
   [Expand]IThreadSafeAccessible Interface
   [Expand]IThreadSafeField Interface
   [Expand]IThreadSafeFieldCollection Interface
   [Expand]IThreadSafeGroup Interface
   [Expand]IThreadSafeGroupCollection Interface
    OLAPDataProvider Enumeration
    PivotArea Enumeration
   [Expand]PivotCellEventArgsBase<TField, TData, TCustomTotal> Class
    PivotChartDataProvideMode Enumeration
    PivotChartDataProvidePriority Enumeration
   [Expand]PivotChartDataSourceRowBase Class
    PivotChartFieldValuesProvideMode Enumeration
    PivotChartItemDataMember Enumeration
    PivotChartItemType Enumeration
   [Expand]PivotCustomFieldValueCellsEventArgsBase<T1, T2> Class
   [Expand]PivotCustomGroupIntervalEventArgsBase<T> Class
    PivotDataArea Enumeration
    PivotDataProcessingEngine Enumeration
   [Expand]PivotDataSource Class
    PivotDefaultMemberFields Enumeration
   [Expand]PivotDrillDownDataRow Class
   [Expand]PivotDrillDownDataSource Class
    PivotExportArea Enumeration
   [Expand]PivotFieldDisplayTextEventArgsBase<T> Class
   [Expand]PivotFieldEventArgsBase<T> Class
    PivotFieldPropertyName Enumeration
   [Expand]PivotFieldValueEventArgsBase<T> Class
   [Expand]PivotFilterBase Class
    PivotFilterType Enumeration
   [Expand]PivotGridAdomdDataSource Class
    PivotGridAllowedAreas Enumeration
    PivotGridBestFitMode Enumeration
   [Expand]PivotGridCustomFieldSortEventArgsBase<T> Class
   [Expand]PivotGridCustomTotalBase Class
   [Expand]PivotGridCustomTotalCollectionBase Class
   [Expand]PivotGridFieldBase Class
   [Expand]PivotGridFieldCollectionBase Class
   [Expand]PivotGridFieldFilterValues Class
   [Expand]PivotGridFieldOptions Class
   [Expand]PivotGridFieldSortBySummaryInfo Class
   [Expand]PivotGridFieldSortCondition Class
   [Expand]PivotGridFieldSortConditionCollection Class
   [Expand]PivotGridGroup Class
   [Expand]PivotGridGroupCollection Class
   [Expand]PivotGridOptionsBase Class
   [Expand]PivotGridOptionsBehaviorBase Class
   [Expand]PivotGridOptionsChartDataSource Class
   [Expand]PivotGridOptionsCustomization Class
   [Expand]PivotGridOptionsData Class
   [Expand]PivotGridOptionsDataField Class
   [Expand]PivotGridOptionsFilterBase Class
   [Expand]PivotGridOptionsLayout Class
   [Expand]PivotGridOptionsOLAP Class
   [Expand]PivotGridOptionsPrint Class
   [Expand]PivotGridOptionsSelection Class
   [Expand]PivotGridOptionsViewBase Class
   [Expand]PivotGridPageSettings Class
    PivotGridResetOptions Enumeration
    PivotGridValueType Enumeration
   [Expand]PivotGridXmlaDataSource Class
    PivotGroupFilterMode Enumeration
   [Expand]PivotGroupFilterValue Class
   [Expand]PivotGroupFilterValues Class
   [Expand]PivotGroupFilterValuesCollection Class
    PivotGroupInterval Enumeration
    PivotKPIGraphic Enumeration
    PivotKPIType Enumeration
    PivotOLAPFilterUsingWhereClause Enumeration
   [Expand]PivotOLAPKPIMeasures Class
   [Expand]PivotOLAPKPIValue Class
   [Expand]PivotOptionsChangedEventArgs Class
    PivotOptionsChangedEventHandler Delegate
   [Expand]PivotOptionsFilterEventArgs Class
    PivotOptionsFilterEventHandler Delegate
    PivotRowTotalsLocation Enumeration
    PivotSortBySummaryOrder Enumeration
    PivotSortLocation Enumeration
    PivotSortMode Enumeration
    PivotSortOrder Enumeration
   [Expand]PivotSummaryDataRow Class
   [Expand]PivotSummaryDataSource Class
   [Expand]PivotSummaryFilter Class
    PivotSummaryFilterMode Enumeration
    PivotSummaryFilterValidity Enumeration
   [Expand]PivotSummaryInterval Class
    PivotTopValueType Enumeration
    PivotTotalsLocation Enumeration
    PivotTotalsVisibility Enumeration
   [Expand]PivotXlsExportOptionsBase Class
   [Expand]PivotXlsxExportOptionsBase Class
   [Expand]PrefilterBase Class
    TopValueMode Enumeration
    UnboundExpressionMode Enumeration
  [Expand]DevExpress.XtraPivotGrid.Customization
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPivotGrid.Localization
  [Expand]DevExpress.XtraPivotGrid.Selection
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.BarCode
  [Expand]DevExpress.XtraPrinting.DataNodes
  [Expand]DevExpress.XtraPrinting.Drawing
  [Expand]DevExpress.XtraPrinting.Export
  [Expand]DevExpress.XtraPrinting.Export.Web
  [Expand]DevExpress.XtraPrinting.Localization
  [Expand]DevExpress.XtraPrinting.Native
  [Expand]DevExpress.XtraPrinting.Shape
  [Expand]DevExpress.XtraPrinting.Shape.Native
  [Expand]DevExpress.XtraPrinting.WebClientUIControl.DataContracts
  [Expand]DevExpress.XtraPrinting.XamlExport
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports
  [Expand]DevExpress.XtraReports.Design
  [Expand]DevExpress.XtraReports.Parameters
  [Expand]DevExpress.XtraReports.ReportGeneration
  [Expand]DevExpress.XtraReports.UI
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.API.Layout
  [Expand]DevExpress.XtraRichEdit.API.Native
  [Expand]DevExpress.XtraRichEdit.API.Native.Implementation
  [Expand]DevExpress.XtraRichEdit.Commands
  [Expand]DevExpress.XtraRichEdit.Export
  [Expand]DevExpress.XtraRichEdit.Export.Html
  [Expand]DevExpress.XtraRichEdit.Export.Rtf
  [Expand]DevExpress.XtraRichEdit.Forms
  [Expand]DevExpress.XtraRichEdit.Import
  [Expand]DevExpress.XtraRichEdit.Localization
  [Expand]DevExpress.XtraRichEdit.Services
  [Expand]DevExpress.XtraRichEdit.Utils
  [Expand]DevExpress.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Compatibility
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.Exchange
  [Expand]DevExpress.XtraScheduler.iCalendar
  [Expand]DevExpress.XtraScheduler.iCalendar.Components
  [Expand]DevExpress.XtraScheduler.Localization
  [Expand]DevExpress.XtraScheduler.Native
  [Expand]DevExpress.XtraScheduler.Outlook
  [Expand]DevExpress.XtraScheduler.Outlook.Interop
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.Tools
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraScheduler.Xml
  [Expand]DevExpress.XtraSpellChecker
  [Expand]DevExpress.XtraSpreadsheet
  [Expand]DevExpress.XtraSpreadsheet.Export
  [Expand]DevExpress.XtraSpreadsheet.Export.Html
  [Expand]DevExpress.XtraSpreadsheet.Import
  [Expand]DevExpress.XtraSpreadsheet.Localization
  [Expand]DevExpress.XtraSpreadsheet.Services
[Expand]Tools and Utilities
 End-User Documentation

DevExpress.XtraPivotGrid Namespace

Contains classes which implement the main functionality of the PivotGridControl.

Expanded Classes

  Class Description
Public class AsyncOperationResult The result of the asynchronous operation.
Public class BaseFilter Serves as base for classes that are filters applied to data displayed in the Pivot Grid.
Public class CrossAreaKey Represents cross area values, by which you want to sort the pivot grid column or row.
Public class CustomCustomizationFormSortEventArgsBase<T> The base class for classes that provide arguments for the CustomCustomizationFormSort and ASPxPivotGrid.CustomCustomizationFormSort events.
Public class CustomFieldDataEventArgsBase<T> Serves as a base for classes that provide data for the CustomUnboundFieldData event.
Public class CustomServerModeSortEventArgsBase<T> Serves as a base for classes that provide data for the CustomServerModeSort event.
Public class FieldValueCellBase<T> Serves as a base for classes that represent field value cells.
Public class PivotCellEventArgsBase<TField, TData, TCustomTotal> Provides data for events which are invoked for particular cells.
Public class PivotChartDataSourceRowBase Serves as the base for classes that represent rows in the datasource passed to the chart control.
Public class PivotCustomFieldValueCellsEventArgsBase<T1, T2> Serves as a base for classes that provide data for the CustomFieldValueCells event.
Public class PivotCustomGroupIntervalEventArgsBase<T> Serves as a base for classes that provide data for the CustomGroupInterval event.
Public class PivotDataSource Serves as the base for classes that represent data sources provided by the pivot grid control (e.g. summary data source, drill-down data source).
Public class PivotDrillDownDataRow Represents a single row in the data source which provides the data used to calculate summaries for individual cells.
Public class PivotDrillDownDataSource Represents a list of the records which are used to calculate summaries for individual cells.
Public class PivotFieldDisplayTextEventArgsBase<T> Provides data for the FieldValueDisplayText event.
Public class PivotFieldEventArgsBase<T> Serves as a base for classes that provide data for all field-related events.
Public class PivotFieldValueEventArgsBase<T> Serves as a base for classes that provide data for the events which are used to customize column and row headers.
Public class PivotFilterBase Serves as the base for classes that are filters applied to data displayed in the PivotGridControl.
Public class PivotGridAdomdDataSource An ADOMD.NET datasource.
Public class PivotGridCustomFieldSortEventArgsBase<T> Serves as a base for classes that provide data for the CustomFieldSort event.
Public class PivotGridCustomTotalBase Represents the base class for the PivotGridCustomTotal class.
Public class PivotGridCustomTotalCollectionBase Represents the base class for the PivotGridCustomTotalCollection class.
Public class PivotGridFieldBase Represents the base class for the PivotGridField class.
Public class PivotGridFieldCollectionBase Represents the base class for the PivotGridFieldCollection class.
Public class PivotGridFieldFilterValues Contains filter values for a specific field.
Public class PivotGridFieldOptions Contains options for a field.
Public class PivotGridFieldSortBySummaryInfo Contains the settings used to sort the values of a column field or row field by summary values in another row/column.
Public class PivotGridFieldSortCondition Represents a sort condition used to identify the column/row by whose values the other field values will be sorted.
Public class PivotGridFieldSortConditionCollection Represent a collection of sort conditions.
Public class PivotGridGroup Represents an individual group of fields.
Public class PivotGridGroupCollection Represents a collection of field groups.
Public class PivotGridOptionsBase Serves as a base for classes that represent the Pivot Grid control's options.
Public class PivotGridOptionsBehaviorBase Serves as the base for classes that provide behavior options for the PivotGrid controls.
Public class PivotGridOptionsChartDataSource Contains options controlling the display of the PivotGrid's data in a DevExpress.XtraCharts.ChartControl.
Public class PivotGridOptionsCustomization Provides customization options for a PivotGrid control.
Public class PivotGridOptionsData Provides data specific options for PivotGrid controls.
Public class PivotGridOptionsDataField Provides the options which control the presentation of data fields in the XtraPivotGrid.
Public class PivotGridOptionsFilterBase Serves as the base class for classes that represent options affecting data filtering.
Public class PivotGridOptionsLayout Contains options that specify how a control layout is stored to, and restored from a storage (a stream, XML file or system registry).
Public class PivotGridOptionsOLAP Provides "OLAP mode"-specific options for a PivotGrid control.
Public class PivotGridOptionsPrint Provides print options for the PivotGrid controls.
Public class PivotGridOptionsSelection Provides selection options for the control.
Public class PivotGridOptionsViewBase Serves as the base for classes that provide view options for the PivotGrid controls.
Public class PivotGridPageSettings Contains print page settings.
Public class PivotGridXmlaDataSource A datasource used to access OLAP data via XMLA.
Public class PivotGroupFilterValue Represents a group filter value.
Public class PivotGroupFilterValues Represents a group filter condition.
Public class PivotGroupFilterValuesCollection Represents a collection of group filter values.
Public class PivotOLAPKPIMeasures Contains the names of the OLAP measures that represent values of a particular KPI.
Public class PivotOLAPKPIValue Represents values of a KPI.
Public class PivotOptionsChangedEventArgs Provides data for the OptionsChanged event.
Public class PivotOptionsFilterEventArgs Provides data for the OptionsChanged event.
Public class PivotSummaryDataRow Represents a summary data source row.
Public class PivotSummaryDataSource Represents a summary data source.
Public class PivotSummaryFilter Contains summary filter settings.
Public class PivotSummaryInterval Contains information about the distribution of summary values within a specific range.
Public class PivotXlsExportOptionsBase Represents the base class for objects which define the PivotGrid's export options specific to XLS format.
Public class PivotXlsxExportOptionsBase Represents the base class for objects which define the PivotGrid's export options specific to XLSX format.
Public class PrefilterBase Represents the base class for Prefilters, that are editors allowing end-users to customize filter criteria at runtime.

Expanded Interfaces

  Interface Description
Public interface IOLAPMember When implemented, represents an OLAP member.
Public interface IPivotCustomSummaryValue When implemented by a class, provides the capability to use custom objects as data field underlying values.
Public interface IThreadSafeAccessible Provides thread-safe access to pivot grid data.
Public interface IThreadSafeField Provides thread-safe access to a pivot grid field.
Public interface IThreadSafeFieldCollection Provides thread-safe access to the pivot grid fields collection.
Public interface IThreadSafeGroup Provides thread-safe access to a field group.
Public interface IThreadSafeGroupCollection Provides thread-safe access to the field groups collection.

Expanded Delegates

  Delegate Description
Public delegate AsyncCompletedHandler References a method executed after an asynchronous operation is completed.
Public delegate PivotOptionsChangedEventHandler Represents a method that will handle the OptionsChanged event.
Public delegate PivotOptionsFilterEventHandler Represents a method that will handle the OptionsChanged event.

Expanded Enumerations

  Enumeration Description
Public enum AdomdVersion Lists values that specify the ADOMD.NET version that should be used to communicate with an OLAP server.
Public enum AllowHideFieldsType Lists values that specify when fields can be hidden by end-users.
Public enum CopyCollapsedValuesMode Lists values that specify how to copy collapsed field values to the Clipboard.
Public enum CopyMultiSelectionMode Lists values that specify how to copy cells to the Clipboard when multiple cells are selected.
Public enum DataFieldUnboundExpressionMode Lists values that specify how the unbound expressions for data fields are calculated.
Public enum ExportCellType Lists values that identify the type of the column or row containing a cell in the exported document.
Public enum OLAPDataProvider Lists values that specify which data provider should be used when binding to an OLAP cube.
Public enum PivotArea Lists the values that specify the areas where the pivot grid fields can be displayed.
Public enum PivotChartDataProvideMode Lists values that specify which data the pivot grid should pass to a bound chart control.
Public enum PivotChartDataProvidePriority 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.
Public enum PivotChartFieldValuesProvideMode Lists values that specify how the PivotGridControl's field values are exported to the chart control.
Public enum PivotChartItemDataMember Lists values that specify the type of a chart data member.
Public enum PivotChartItemType Lists values that specify the type of a PivotGridControl's item to be represented in a ChartControl.
Public enum PivotDataArea Contains values that specify the areas where the data field headers can be displayed.
Public enum PivotDataProcessingEngine Lists values that specify an engine used to perform data processing (aggregation, summarization, etc.) in the pivot grid.
Public enum PivotDefaultMemberFields Lists values that specify for which fields the pivot grid processes only data related to their default members.
Public enum PivotExportArea Lists values that specify the cell location in the exported Excel document.
Public enum PivotFieldPropertyName Lists values that identify properties of fields.
Public enum PivotFilterType Contains the values that specify a field's filter type in the XtraPivotGrid control.
Public enum PivotGridAllowedAreas Lists the areas within which a field can be positioned.
Public enum PivotGridBestFitMode Contains values that specify which elements are taken into account when calculating the best-fit width for columns.
Public enum PivotGridResetOptions Lists values that specify which options are reset before loading the layout.
Public enum PivotGridValueType Lists values that specify the types of column and row field values.
Public enum PivotGroupFilterMode Lists values that specify the filtering mode used for grouped fields.
Public enum PivotGroupInterval Contains values that specify how the values of a specific column or row field are combined into groups.
Public enum PivotKPIGraphic Lists values that specify the graphic set used to indicate KPI values.
Public enum PivotKPIType Lists KPI types.
Public enum PivotOLAPFilterUsingWhereClause Lists values that specify whether to use the WHERE clause in an MDX query, when filtering against filter fields in OLAP mode.
Public enum PivotRowTotalsLocation Lists values that specify the location of the row and grand totals.
Public enum PivotSortBySummaryOrder Lists values that specify the sort order applied to a field when sorting by summaries is enabled for it.
Public enum PivotSortLocation Lists values that specify a target UI element to whose values sorting is applied.
Public enum PivotSortMode Lists the values that specify how a field's data should be sorted.
Public enum PivotSortOrder Lists the values that specify the sort order of pivot grid fields.
Public enum PivotSummaryFilterMode Lists values that specify whether summary filtering should be applied to the last aggregation level or to the specified one.
Public enum PivotSummaryFilterValidity Lists values that specify whether the specified value range and aggregation level are valid.
Public enum PivotTopValueType Lists the values that specify how the number of Top Values is determined.
Public enum PivotTotalsLocation Lists values that specify the location of the column totals.
Public enum PivotTotalsVisibility Contains values that specify which summary totals are displayed for a specific column field or row field.
Public enum TopValueMode Lists values that specify how the top n values for a specified data field are calculated.
Public enum UnboundExpressionMode Lists values that specify how the unbound expressions for a specified data field are calculated.
How would you rate this topic?​​​​​​​