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 MainWindow.xaml.cs/MainWindow.xaml.vb).
- MainWindow.xaml (VB: MainWindow.xaml)
- MainWindow.xaml.cs (VB: MainWindow.xaml.vb)
- DistinctCountFunction.cs (VB: DistinctCountFunction.vb)
- Pivot Grid for WinForms - How to Create a Custom Summary Type to Display the Distinct Value Count
- Pivot Grid for WinForms - How to Aggregate Data by the Field's First Value
- Pivot Grid for Web Forms - How to Aggregate Data by the Field's First Value
(you will be redirected to DevExpress.com to submit your response)