Pivot Grid for WinForms - Create a Custom Summary to Display a Distinct Value Count

This example demonstrates how to count distinct values (the number of orders with equal product quantities) and display the result in the Pivot Grid.

Data Field	Expression
Count Distinct	DistinctCount([OrderID])

Call the CriteriaOperator.RegisterCustomFunction method to register a custom function in your project (see Form1.cs/Form1.vb).

Files to Review

• Form1.cs (VB: Form1.vb)

Documentation

• Summarization
• Pivot Grid Expression Syntax
• Bind Pivot Grid Fields to Calculated Expressions
• Binding to Excel Data Source

More Examples

• WPF - How to Create a Custom Summary Type to Display the Distinct Value Count

Does this example address your development requirements/objectives?

(you will be redirected to DevExpress.com to submit your response)