Totals

using DevExpress.Xpf.PivotGrid;

// Gets a reference to the CategoryName field.  
PivotGridField field = pivotGridControl1.Fields["CategoryName"];
pivotGridControl1.BeginUpdate();
try {
   // Clears the custom total collection.  
   field.CustomTotals.Clear();
   // Adds items to the custom total collection with   
   // the specified summary types.  
   field.CustomTotals.Add(FieldSummaryType.Sum);
   field.CustomTotals.Add(FieldSummaryType.Max);
   // Makes the custom totals visible for this field.  
   field.TotalsVisibility = FieldTotalsVisibility.CustomTotals; 
}
finally {
   pivotGridControl1.EndUpdate();
}

Imports using DevExpress.Xpf.PivotGrid

' Gets a reference to the CategoryName field.  
Dim field As PivotGridField = pivotGridControl1.Fields("CategoryName")
pivotGridControl1.BeginUpdate()
Try 
   ' Clears the custom total collection.  
   field.CustomTotals.Clear()
   ' Adds items to the custom total collection with   
   ' the specified summary types.  
   field.CustomTotals.Add(FieldSummaryType.Sum)
   field.CustomTotals.Add(FieldSummaryType.Max)
   ' Makes the custom totals visible for this field.  
   field.TotalsVisibility = FieldTotalsVisibility.CustomTotals
Finally 
   pivotGridControl1.EndUpdate()
End Try 

<dxpg:PivotGridControl x:Name="pivotGridControl1" DataSource="{Binding Data, Source={StaticResource TypedSimpleSource}}">
    <dxpg:PivotGridControl.Fields>
        <dxpg:PivotGridField Area="RowArea" Caption="Category" FieldName="CategoryName" 
                             AreaIndex="0" TotalsVisibility="CustomTotals">
            <dxpg:PivotGridField.CustomTotals>
                <dxpg:PivotGridCustomTotal SummaryType="Sum" />
                <dxpg:PivotGridCustomTotal SummaryType="Max" />
            </dxpg:PivotGridField.CustomTotals>
        </dxpg:PivotGridField>
        <dxpg:PivotGridField Area="ColumnArea" FieldName="Country" AreaIndex="0"/>
        <dxpg:PivotGridField Area="DataArea" FieldName="Extended Price" AreaIndex="0" Caption="Total Sum"/>
        <dxpg:PivotGridField Area="RowArea" Caption="Product" FieldName="ProductName" AreaIndex="1"/>
    </dxpg:PivotGridControl.Fields>
</dxpg:PivotGridControl>