[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Collapse]Design-Time Features
    [Collapse]PivotGrid Designer
      Options Page
      Fields Page
      Groups Page
      Layout Page
      In-place Editor Repository Page
      Appearances Page
      Format Rules Page
      Print Appearances Page
      Print Settings Page
     On-form Object Access
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Gantt Control
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[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]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Fields Page

The Fields page allows you to create or delete fields, and customize individual fields using the built-in property grid.

Expanded Field List

This list displays the available data source fields. The Field List can be hidden/shown by clicking the button. The bold items indicate that the Pivot Grid Control has no field bound to this data source field. You can double click or drag items to the PivotGrid Fields to create fields bound to the data source field.

Expanded PivotGrid Fields

This list displays the Pivot Grid Control fields contained within the PivotGridControl.Fields collection. The settings of the currently selected field can be accessed and changed via the property grid. Note that you can customize the settings for multiple fields simultaneously. Hold down the SHIFT or CTRL key while clicking field names to select multiple fields.

Expanded Button Pane

This pane displays the buttons that are used to manage the fields collection.



The Show/Hide Field List button displays or hides the Field List containing the available data source fields.

The Search Boxes button displays or hides search panels in the Field List and PivotGrid Fields panes.

The Retrieve Fields button creates fields for all fields in the bound data source. Any existing fields are deleted first. New fields are created in the same order as the bound fields appear in the data source.

The Add Field button creates a new field and adds it to the collection.

The Insert Field button creates a new field and adds it at the currently selected position.

The Remove Field button removes the selected field from the collection.

Hold down the SHIFT or CTRL key while clicking field names to select and remove multiple fields.

The Move Up button swaps the selected field with the previous item.

The Move Down button swaps the selected field with the next item.

Is this topic helpful?​​​​​​​