本文將通過一個具體是示例為大家演示如何將多個字段合并成組。

本例中合并的字段為Country、Region和City這三個字段，我們將它們合并為一個組，進而實現：當我們拖拽字段Country到另一個區域時，Region和City也會自動跟著進入新的區域；當我們拖拽字段Region到另一個區域時，City也會自動跟著進入新的區域。下圖演示的就是拖拽字段Region到Filter Header Area的效果圖：

代碼如下：

C#

using DevExpress.XtraPivotGrid;

PivotGridField fieldCountry = pivotGridControl1.Fields["Country"];
PivotGridField fieldRegion = pivotGridControl1.Fields["Region"];
PivotGridField fieldCity = pivotGridControl1.Fields["City"];
// Add a new group which combines the fields.
pivotGridControl1.Groups.Add(new PivotGridField[] {fieldCountry, fieldRegion, fieldCity});

VB

Imports DevExpress.XtraPivotGrid

Dim fieldCountry As PivotGridField = PivotGridControl1.Fields("Country")
Dim fieldRegion As PivotGridField = PivotGridControl1.Fields("Region")
Dim fieldCity As PivotGridField = PivotGridControl1.Fields["City")
' Add a new group which combines the fields.
PivotGridControl1.Groups.Add(new PivotGridField() {fieldCountry, fieldRegion, fieldCity})

慧都學院2017全新DevExpress線下研修班火熱報名中！