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
   [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]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]ASP.NET Core 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]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

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