Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Collapse]Binding to Data
     Binding to Data Overview
    [Expand]OLAP Data Source
    [Expand]Database Server Mode
     Unbound Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Data Formatting
   [Expand]Layout
   [Expand]Appearance
   [Expand]Data Export
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]Examples
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET 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]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Unbound Data

The Pivot Grid supports bound and unbound (calculated) fields. Unbound fields are not bound to any data field in the pivot grid's data source. They can be sorted, grouped and filtered in the same manner as bound fields. When exporting the pivot grid, the contents of the unbound fields will be exported as well.

Unbound fields are calculated fields. You can provide data for them by specifying a string formula or by handling the ASPxPivotGrid.CustomUnboundFieldData event.

Expanded Unbound Fields Overview

An unbound column must meet the following requirements:

Expanded Providing Data for Unbound Fields

To provide data for unbound fields, use one of two methods:

Note

Providing data for unbound fields using the ASPxPivotGrid.CustomUnboundFieldData event is not supported in server mode.

Expanded Example: How to Display Unbound Data

Show Me

A complete sample project is available in the DevExpress Code Examples database at http://www.devexpress.com/example=E1892.

The following example shows how to add unbound fields to the ASPxPivotGrid.


The 'DiscountAmount' unbound field's values are calculated using the PivotGridFieldBase.UnboundExpression property, while the 'PriceWithDiscount' unbound field is populated by handling the ASPxPivotGrid.CustomUnboundFieldData event.

See Also:
How to calculate custom values based on other field values
Unbound Data

How would you rate this topic?​​​​​​​