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

PivotGridFieldOptions Properties

Public Properties

See Also