Chat Now
Cart
My Downloads
Free Trial
Log In
General Information
WinForms Controls
ASP.NET Controls and MVC Extensions
ASP.NET Bootstrap Controls
ASP.NET Core Bootstrap Controls
WPF Controls
Xamarin Controls
Windows 10 App Controls
Office File API
Reporting
Report and Dashboard Server
Dashboard
eXpressApp Framework
eXpress Persistent Objects
CodeRush
CodeRush Classic
Cross-Platform Core Libraries
Core Library Assemblies
DevExpress Data Library
DevExpress Pivot Grid Core Library
Miscellaneous
API Reference
DevExpress.Data
DevExpress.Data.Browsing
DevExpress.Data.Browsing.Design
DevExpress.Data.Camera
DevExpress.Data.Controls
DevExpress.Data.Controls.ExpressionEditor
DevExpress.Data.Entity
DevExpress.Data.Filtering
DevExpress.Data.Filtering.Exceptions
DevExpress.Data.Filtering.Helpers
DevExpress.Data.Linq
DevExpress.Data.ODataLinq
DevExpress.Data.PivotGrid
DevExpress.Data.PLinq
DevExpress.Data.TreeList
DevExpress.Data.Utils
DevExpress.Data.Utils.ServiceModel
DevExpress.Data.WcfLinq
DevExpress.Data.WizardFramework
DevExpress.Data.XtraReports.DataProviders
DevExpress.Data.XtraReports.Labels
DevExpress.Data.XtraReports.ServiceModel
DevExpress.Data.XtraReports.ServiceModel.DataContracts
DevExpress.Data.XtraReports.Wizard
DevExpress.Data.XtraReports.Wizard.Presenters
DevExpress.Data.XtraReports.Wizard.Views
DevExpress.DataAccess
DevExpress.DataAccess.ConnectionParameters
DevExpress.DataAccess.DataFederation
DevExpress.DataAccess.EntityFramework
DevExpress.DataAccess.Excel
DevExpress.DataAccess.ExpressionEditor
DevExpress.DataAccess.Json
DevExpress.DataAccess.Localization
DevExpress.DataAccess.ObjectBinding
DevExpress.DataAccess.Sql
DevExpress.DataAccess.Sql.DataApi
DevExpress.DataAccess.UI
DevExpress.DataAccess.UI.Design
DevExpress.DataAccess.UI.EntityFramework
DevExpress.DataAccess.UI.Excel
DevExpress.DataAccess.UI.Localization
DevExpress.DataAccess.UI.ObjectBinding
DevExpress.DataAccess.UI.Sql
DevExpress.DataAccess.UI.Wizard
DevExpress.DataAccess.UI.Wizard.Services
DevExpress.DataAccess.UI.Wizard.Views
DevExpress.DataAccess.Web
DevExpress.DataAccess.Wizard
DevExpress.DataAccess.Wizard.Model
DevExpress.DataAccess.Wizard.Presenters
DevExpress.DataAccess.Wizard.Services
DevExpress.DataAccess.Wizard.Views
DevExpress.Diagram.Core
DevExpress.Diagram.Core.Layout
DevExpress.Diagram.Core.Localization
DevExpress.Diagram.Core.Shapes
DevExpress.Diagram.Core.Themes
DevExpress.DocumentServices.ServiceModel
DevExpress.DocumentServices.ServiceModel.Client
DevExpress.DocumentServices.ServiceModel.DataContracts
DevExpress.DocumentView
DevExpress.Entity.Model
DevExpress.Entity.ProjectModel
DevExpress.Export
DevExpress.Export.Xl
DevExpress.Map
DevExpress.Mvvm
DevExpress.Mvvm.DataAnnotations
DevExpress.Mvvm.DataModel
DevExpress.Mvvm.Gantt
DevExpress.Mvvm.ModuleInjection
DevExpress.Mvvm.UI
DevExpress.Mvvm.Utils
DevExpress.Mvvm.ViewModel
DevExpress.Office.Crypto
DevExpress.PivotGrid.DataBinding
DevExpress.PivotGrid.Printing
DevExpress.Printing
DevExpress.Printing.Core
DevExpress.Printing.ExportHelpers
DevExpress.ReportServer.Printing
DevExpress.ReportServer.Printing.Services
DevExpress.ReportServer.ServiceModel.Client
DevExpress.ReportServer.ServiceModel.ConnectionProviders
DevExpress.ReportServer.ServiceModel.DataContracts
DevExpress.Schedule
DevExpress.Security.Resources
DevExpress.Services
DevExpress.Sparkline
DevExpress.TreeMap
DevExpress.Utils
DevExpress.Utils.Commands
DevExpress.Utils.Controls
DevExpress.Utils.Filtering
DevExpress.Utils.Filtering.Internal
DevExpress.Utils.IoC
DevExpress.Utils.Localization
DevExpress.Utils.Serializing.Helpers
DevExpress.Utils.Svg
DevExpress.WebUtils
DevExpress.Xpf.Core
DevExpress.Xpf.Printing
DevExpress.Xpo
DevExpress.Xpo.DB
DevExpress.Xpo.DB.Exceptions
DevExpress.Xpo.DB.Helpers
DevExpress.Xpo.Helpers
DevExpress.XtraCharts
DevExpress.XtraCharts.Localization
DevExpress.XtraCharts.Native
DevExpress.XtraCharts.Printing
DevExpress.XtraEditors
DevExpress.XtraEditors.DXErrorProvider
DevExpress.XtraExport.Csv
DevExpress.XtraGauges.Base
DevExpress.XtraGauges.Core
DevExpress.XtraGauges.Core.Base
DevExpress.XtraGauges.Core.Drawing
DevExpress.XtraGauges.Core.Localization
DevExpress.XtraGauges.Core.Model
DevExpress.XtraGauges.Core.Primitive
DevExpress.XtraGrid
DevExpress.XtraPivotGrid
AdomdVersion Enumeration
AllowHideFieldsType Enumeration
AsyncCompletedHandler Delegate
AsyncOperationResult Class
BaseFilter Class
CalculationDirection Enumeration
CalculationPartitioningCriteria Enumeration
CopyCollapsedValuesMode Enumeration
CopyMultiSelectionMode Enumeration
CrossAreaKey Class
CustomCustomizationFormSortEventArgsBase<T> Class
CustomFieldDataEventArgsBase<T> Class
CustomServerModeSortEventArgsBase<T> Class
DataBindingBase Class
DataFieldUnboundExpressionMode Enumeration
DifferenceTarget Enumeration
DifferenceType Enumeration
ExportCellType Enumeration
FieldValueCellBase<T> Class
IOLAPMember Interface
IPivotCustomSummaryValue Interface
IThreadSafeAccessible Interface
IThreadSafeField Interface
IThreadSafeFieldCollection Interface
IThreadSafeGroup Interface
IThreadSafeGroupCollection Interface
OLAPDataProvider Enumeration
PivotArea Enumeration
PivotCellEventArgsBase<TField, TData, TCustomTotal> Class
PivotChartDataProvideMode Enumeration
PivotChartDataProvidePriority Enumeration
PivotChartDataSourceRowBase Class
PivotChartFieldValuesProvideMode Enumeration
PivotChartItemDataMember Enumeration
PivotChartItemType Enumeration
PivotCustomFieldValueCellsEventArgsBase<T1, T2> Class
PivotCustomGroupIntervalEventArgsBase<T> Class
PivotDataArea Enumeration
PivotDataProcessingEngine Enumeration
PivotDataSource Class
PivotDefaultMemberFields Enumeration
PivotDrillDownDataRow Class
PivotDrillDownDataSource Class
PivotExportArea Enumeration
PivotFieldDisplayTextEventArgsBase<T> Class
PivotFieldEventArgsBase<T> Class
PivotFieldPropertyName Enumeration
PivotFieldValueEventArgsBase<T> Class
PivotFilterBase Class
PivotFilterType Enumeration
PivotGridAdomdDataSource Class
PivotGridAllowedAreas Enumeration
PivotGridBestFitMode Enumeration
PivotGridCustomFieldSortEventArgsBase<T> Class
PivotGridCustomTotalBase Class
PivotGridCustomTotalCollectionBase Class
PivotGridFieldBase Class
PivotGridFieldCollectionBase Class
PivotGridFieldFilterValues Class
PivotGridFieldOptions Class
PivotGridFieldOptions Members
PivotGridFieldOptions Constructor
PivotGridFieldOptions Properties
AllowDrag Property
AllowDragInCustomizationForm Property
AllowExpand Property
AllowFilter Property
AllowFilterBySummary Property
AllowRunTimeSummaryChange Property
AllowSort Property
AllowSortBySummary Property
GroupFilterMode Property
HideEmptyVariationItems Property
OLAPFilterByUniqueName Property
OLAPFilterUsingWhereClause Property
OLAPUseNonEmpty Property
ShowCustomTotals Property
ShowGrandTotal Property
ShowInCustomizationForm Property
ShowInExpressionEditor Property
ShowInFilter Property
ShowInPrefilter Property
ShowSummaryTypeName Property
ShowTotals Property
ShowValues Property
PivotGridFieldOptions Events
PivotGridFieldSortBySummaryInfo Class
PivotGridFieldSortCondition Class
PivotGridFieldSortConditionCollection Class
PivotGridGroup Class
PivotGridGroupCollection Class
PivotGridOptionsBase Class
PivotGridOptionsBehaviorBase Class
PivotGridOptionsChartDataSource Class
PivotGridOptionsCustomization Class
PivotGridOptionsData Class
PivotGridOptionsDataField Class
PivotGridOptionsFilterBase Class
PivotGridOptionsLayout Class
PivotGridOptionsOLAP Class
PivotGridOptionsPrint Class
PivotGridOptionsSelection Class
PivotGridOptionsViewBase Class
PivotGridPageSettings Class
PivotGridResetOptions Enumeration
PivotGridValueType Enumeration
PivotGridXmlaDataSource Class
PivotGroupFilterMode Enumeration
PivotGroupFilterValue Class
PivotGroupFilterValues Class
PivotGroupFilterValuesCollection Class
PivotGroupInterval Enumeration
PivotKPIGraphic Enumeration
PivotKPIType Enumeration
PivotOLAPFilterUsingWhereClause Enumeration
PivotOLAPKPIMeasures Class
PivotOLAPKPIValue Class
PivotOptionsChangedEventArgs Class
PivotOptionsChangedEventHandler Delegate
PivotOptionsFilterEventArgs Class
PivotOptionsFilterEventHandler Delegate
PivotRowTotalsLocation Enumeration
PivotSortBySummaryOrder Enumeration
PivotSortLocation Enumeration
PivotSortMode Enumeration
PivotSortOrder Enumeration
PivotSummaryDataRow Class
PivotSummaryDataSource Class
PivotSummaryFilter Class
PivotSummaryFilterMode Enumeration
PivotSummaryFilterValidity Enumeration
PivotSummaryInterval Class
PivotTopValueType Enumeration
PivotTotalsLocation Enumeration
PivotTotalsVisibility Enumeration
PivotXlsExportOptionsBase Class
PivotXlsxExportOptionsBase Class
PrefilterBase Class
RankType Enumeration
TopValueMode Enumeration
UnboundExpressionMode Enumeration
DevExpress.XtraPivotGrid.Customization
DevExpress.XtraPivotGrid.Data
DevExpress.XtraPivotGrid.Localization
DevExpress.XtraPivotGrid.Selection
DevExpress.XtraPrinting
DevExpress.XtraPrinting.BarCode
DevExpress.XtraPrinting.Caching
DevExpress.XtraPrinting.DataNodes
DevExpress.XtraPrinting.Drawing
DevExpress.XtraPrinting.Export
DevExpress.XtraPrinting.Export.Web
DevExpress.XtraPrinting.Localization
DevExpress.XtraPrinting.Native
DevExpress.XtraPrinting.Shape
DevExpress.XtraPrinting.Shape.Native
DevExpress.XtraPrinting.WebClientUIControl.DataContracts
DevExpress.XtraPrinting.XamlExport
DevExpress.XtraPrintingLinks
DevExpress.XtraReports
DevExpress.XtraReports.Design
DevExpress.XtraReports.Expressions
DevExpress.XtraReports.Parameters
DevExpress.XtraReports.ReportGeneration
DevExpress.XtraReports.UI
DevExpress.XtraScheduler
DevExpress.XtraScheduler.Compatibility
DevExpress.XtraScheduler.Drawing
DevExpress.XtraScheduler.Exchange
DevExpress.XtraScheduler.iCalendar
DevExpress.XtraScheduler.iCalendar.Components
DevExpress.XtraScheduler.Localization
DevExpress.XtraScheduler.Native
DevExpress.XtraScheduler.Outlook
DevExpress.XtraScheduler.Outlook.Interop
DevExpress.XtraScheduler.Reporting
DevExpress.XtraScheduler.Services
DevExpress.XtraScheduler.Services.Implementation
DevExpress.XtraScheduler.Tools
DevExpress.XtraScheduler.UI
DevExpress.XtraScheduler.Xml
DevExpress.XtraSpellChecker
DevExpress.XtraSpellChecker.Rules
Tools and Utilities
End-User Documentation
Cross-Platform Core Libraries
>
DevExpress.XtraPivotGrid
>
PivotGridFieldOptions
View this topic on
docs.devexpress.com
(
Learn more
)
PivotGridFieldOptions Properties
Contains options for a field.
Public Properties
Show:
Inherited
Name
Description
AllowDrag
Gets or sets whether an end-user is allowed to drag the
Field Header
.
AllowDragInCustomizationForm
Gets or sets whether end-users are allowed to drag field headers between areas in the
Customization Form
.
AllowExpand
Gets or sets whether an end-user is allowed to expand/collapse the rows or columns which correspond to the current field.
AllowFilter
Gets or sets whether an end-user can apply a filter to the current field.
AllowFilterBySummary
Gets or sets whether end-users are allowed to filter pivot grid data by summaries calculated against the current data field.
AllowRunTimeSummaryChange
Gets or sets whether an end-user can change the data field's summary type.
AllowSort
Gets or sets whether an end-user can modify the field's current sort order.
AllowSortBySummary
Gets or sets whether end-users can sort the current row/column field values by other column/row summary values.
GroupFilterMode
Gets or sets the filtering mode used for the field's owner group.
HideEmptyVariationItems
Gets or sets whether the first (empty) column/row that displays variation data for the current data field must be hidden.
OLAPFilterByUniqueName
Gets or sets whether PivotGridControl should take into account OLAP member values or unique names when filtering data in an
OLAP
mode.
OLAPFilterUsingWhereClause
Gets or sets whether to use the WHERE or subselect clause in an MDX query, when filtering against
filter fields
in OLAP mode.
OLAPUseNonEmpty
Gets or sets whether the
NonEmpty
function should be used in MDX queries for the current measure.
ShowCustomTotals
Gets or sets whether
Custom Totals
that correspond to the current
Column Field
or
Row Field
are visible.
ShowGrandTotal
Gets or sets whether
Grand Totals
that correspond to the current
Data Field
are visible.
ShowInCustomizationForm
Gets or sets whether the field's header is displayed within the
Customization Form
when the field is hidden.
ShowInExpressionEditor
Gets or sets whether the current field is available in the
Expression Editor
's field list.
ShowInFilter
Gets or sets whether the field is available for selection in the Filter Editor.
ShowInPrefilter
Gets or sets whether the field is shown in
Prefilter
.
ShowSummaryTypeName
Gets or sets whether the summary type is displayed within the data field's header.
ShowTotals
Gets or sets whether
Totals
that correspond to the current
Data Field
are visible.
ShowValues
Gets or sets whether
data cells
that correspond to the current
Data Field
are visible.
Top
See Also
PivotGridFieldOptions Class
PivotGridFieldOptions Members
DevExpress.XtraPivotGrid Namespace
PivotGridFieldBase.Options
DevExpress.XtraPivotGrid.PivotGridControl.OptionsCustomization
Is this topic helpful?
Additional Feedback
Close
Please tell us how you’d like us to improve this topic.
Send