彩票走势图

在本例中，将为你展示在DevEXpress中如何添加未绑定的字段到XtraPivotGrid控件，我们添加的字段为订单总和。

首先，创建一个名为Total Sum的字段。
其次，将字段 PivotGridFieldBase.UnboundType 属性设为UnboundColumnType.Decimal。
最后，最后，用数据填充字段。

VB

Imports DevExpress.XtraPivotGrid

' Create a field with the specified field name.
Dim unboundField As PivotGridField = pivotGridControl1.Fields.Add("Total Sum",
  PivotArea.DataArea)
' Specify the type of the field's values.
unboundField.UnboundType = DevExpress.Data.UnboundColumnType.Decimal

' Populates the unbound field.
Private Sub pivotGridControl1_CustomUnboundFieldData(ByVal sender As System.Object, _
  ByVal e As CustomFieldDataEventArgs)
   If (e.Field.FieldName = "Total Sum") Then
      Dim unitPrice As Decimal = Convert.ToDecimal(e.GetListSourceColumnValue("UnitPrice"))
      Dim qty As Int32 = Convert.ToInt32(e.GetListSourceColumnValue("Quantity"))
      Dim discount As Decimal = Convert.ToDecimal(e.GetListSourceColumnValue("Discount"))
      e.Value = unitPrice * qty * (1 - discount)
   End If
End Sub

C#

using DevExpress.XtraPivotGrid;

// Create a field with the specified field name.
PivotGridField unboundField = pivotGridControl1.Fields.Add("Total Sum",
  PivotArea.DataArea);
// Specify the type of the field's values.
unboundField.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;

// Populates the unbound field.
private void pivotGridControl1_CustomUnboundFieldData(object sender,
  CustomFieldDataEventArgs e) {
   if(e.Field.FieldName == "Total Sum") {
      decimal unitPrice = Convert.ToDecimal(e.GetListSourceColumnValue("UnitPrice"));
      int qty = Convert.ToInt32(e.GetListSourceColumnValue("Quantity"));
      decimal discount = Convert.ToDecimal(e.GetListSourceColumnValue("Discount"));
      e.Value = unitPrice*qty*(1-discount);
   }
}