windowsforms-1796-controls-and-libraries-pivot-grid-fundamentals-hierarchical-value-presentation.md
The Pivot Grid component can display data hierarchically at multiple detail levels in a single report. Multi-level hierarchies allow users to manage the Pivot Grid’s layout and how detailed data should be in a report.
For example, you can drop existing fields onto one area to create additional fields with different detail levels. Once a hierarchy is generated, you can join fields in a continuous group to allow users to interact with it as a single field.
The following sections describe how to use data detail levels for different scenarios:
A hierarchy can enhance a report when source data contains several tables. For example, in the image below, the Categories table joined with Products table by the CategoryID field. In this case, you can create a virtual table (view) as a container for the CategoryName and ProductName fields from joined tables in the database.
You can drop two fields onto the column or row area to display the Category → Product hierarchy on an axis. Users can browse data summarized by categories and view details for each product within a report.
The parent value (Seafood) displays the expand button that allows users to switch between the “by Product” and “by Category” views. Alternatively, they can use the built-in field value context menu. As a result, a single report can display both raw and sorted data.
You can combine unique values of a data field into groups. For example, use group intervals if you have sales records for each day, and you want to show the total sales for a year. The following list contains group interval examples:
Numeric Date-Time Alphabetical
As a result, you can have several fields bound to the same data field with different detail levels. Refer to Grouping for more information about predefined and custom group intervals.
To implement a Year → Quarter → Month hierarchy from a Date-Time field, do the following:
The following fields implement the Year → Quarter → Month hierarchy:
Year
Quarter
Month
The image below shows the resulting hierarchy:
Hierarchy fields, located in row and column areas form different levels of data detail. A pair of column and row fields defines the visual detail level. Cells that display values of these fields belong to the same detail level if they are located at the intersections of columns and rows.
You can use different detail levels to apply summary filter or conditional formatting rules. For example, the initial summary filter applies to the last level’s cells. Set the PivotSummaryFilter.Mode property one of the following values to change the detail level:
Last LevelThe intersection of the last fields in the column and row areas defines the last level of detail. Specific LevelA user specifies column and row fields. The image below shows detail levels defined by different field combinations: