This example demonstrates how to determine the value type when you calculate custom summary values.

• MainWindow.xaml (VB: MainWindow.xaml)
• MyDataContext.cs (VB: MyDataContext.vb)

Follow the steps below to create a custom summary.

1. Create an ExpressionDataBinding object.

2. Pass the following expression in its constructor as a parameter:

   iif(IsTotal([fieldColumnGroup]),'Grand Total',IsTotal([fieldRowGroup]),'Grand Total',IsTotal([fieldColumn]),'Total',IsTotal([fieldRow]),'Total',Sum([Data]))
   

3. Assign the ExpressionDataBinding instance to the fieldData field's DataBinding property.

• Pivot Grid Expression Syntax
• Custom Summaries

How to Create a Custom Summary to Display the Distinct Value Count