Pivot Grid for Web Forms - How to Specify Custom Summary Values for Total, Grand Total, and Ordinary Cells

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

Files to Look at

• Default.aspx (VB: Default.aspx)
• Default.aspx.cs (VB: Default.aspx.vb)

Example Overview

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.

Documentation

• Pivot Grid Expression Syntax
• Custom Summaries

More Examples

Pivot Grid for Web Forms - How to Aggregate Data by the Field's First Value