[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
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Reporting
  [Expand]Chart Control
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Data Formatting
   [Collapse]Layout
     Hierarchical Value Arrangement
     Compact Layout for Hierarchical Row Values
     Field Location and Order
     Data Cell Layout
     Field Groups
    [Expand]Customization Form
     Save and Restore Layout
    [Expand]Paging and Scrolling
   [Expand]Appearance
   [Expand]Export
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]Examples
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Scheduler
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Gauges
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [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]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Hierarchical Value Arrangement

When several fields are placed on the column or row area, field values are automatically arranged into a tree structure with expandable parents (see the image below). End-users can expand and collapse child groups to see more summarized or more detailed reports.

 

The table below lists the properties and methods, allowing you to customize the pivot grid's layout in code (e.g. rearrange fields, change their expanded state, etc.):

Member Description
PivotGridFieldBase.Area Specifies the area of the Pivot Grid in which the field is displayed.
PivotGridFieldBase.AreaIndex Specifies the field's index from amongst the other fields displayed within the same area.
PivotGridFieldBase.SetAreaPosition Positions the field in the specified area and at the specified location.
ASPxPivotGrid.ExpandAll Expands all the columns and rows in the pivot grid.
ASPxPivotGrid.CollapseAll Collapses all the columns and rows in the pivot grid.
ASPxPivotGrid.ExpandAllColumns Expands all columns.
ASPxPivotGrid.CollapseAllColumns Collapses all columns.
ASPxPivotGrid.ExpandAllRows Expands all rows.
ASPxPivotGrid.CollapseAllRows Collapses all rows.
ASPxPivotGrid.ExpandValue Expands a specific column or row that is identified by the specified values.
ASPxPivotGrid.CollapseValue Collapses a specific column or row that is identified by the specified values.
PivotGridFieldBase.ExpandAll Expands all columns/rows which correspond to a column field or row field.
PivotGridFieldBase.CollapseAll Collapses all the rows/columns which correspond to a column field or row field.
PivotGridFieldBase.ExpandValue Expands the column/row that contains the specified value.
PivotGridFieldBase.CollapseValue Collapses the column/row that contains the specified value.

Expanded See Also

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