[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Collapse]Pivot Grid
   [Expand]Getting Started
    [Collapse]Information Presentation
      Information Presentation Basics
      Hierarchical Value Presentation
     Product Class Structure
     Attached Properties
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Printing and Exporting
   [Expand]End-User Interaction
   [Expand]MVVM Enhancements
   [Expand]UI Elements
   [Expand]End-User Capabilities
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[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)

Hierarchical Value Presentation

By displaying values hierarchically you can bring multiple detail levels to a single report. The more fields take part in a hierarchy, the more flexible a report is. Multi-level hierarchies allow end-users to view data from different perspectives, thus giving them total control over the layout of the data in a report. At the same time, you only have to create a single report and do not need to change a single thing to show more or less detail within a report.

There are numerous Use Cases that hierarchies are suitable for, from dropping existing fields into a single area to creating additional fields with different detail levels - with Pivot Grid, everything is at your fingertips. Once a hierarchy has been generated, you can join fields into a non-breakable group, so end-users can see and use it as a single field.

Expanded Scenario #1: Transform Master-Detail Relationships into a Hierarchy

The most obvious situation when a hierarchy may enhance a report is when source data contains lookup fields. For example, in the image below, the OrderDetails table contains a lookup field (ProductID) that refers to the Products table. In this case, you need to create a virtual table (a view), which contains fields from one or more real tables in the database. For example, the SalesPerson view contains fields from the OrderDetails and Products tables. In this case, you can display the OrderDetail-Product hierarchy on an axis. Simply drop two headers into the same area to achieve this result. End-users will be able to browse compact data summarized by trademarks and view details for each car model within a single report.

As you can see, the parent value (Beverages) displays expand button that can be used to switch from the "by Product" view to the "by Category" view and vice versa. This can also be done using the built-in Field Value Context Menu. Thus end-users can browse rough or sorted data within the same report, and you do not have to redo a single thing in your report.

Expanded Scenario #2: Apply Different Levels of Detail to the Same Field

Another application of value hierarchies relies on the fact that Pivot Grid control allows you customize a field's detail level. You do not necessarily have to display all the unique values in a data field. The values can be united into groups such as numeric intervals, date-time intervals, alphabetic groups, etc. Thus, you can have several fields bound to the same data field with different detail levels. For instance, the following image illustrates you how to implement a Year->Quarter->Month hierarchy using a single Date-Time field.

Note that in addition to numerous built-in group intervals, you can easily create your own. Please refer to the Grouping Field Values on Axes topic for additional information.

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