This example shows how to aggregate data by the field's first value.
- WebForm1.aspx (VB: WebForm1.aspx)
- WebForm1.aspx.cs (VB:WebForm1.aspx.vb)
- FirstValueFunction.cs (VB: FirstValueFunction.vb)
This example adds the FirstValue([ProductName])
expression to the First Sold Product field. The expression returns the first sold product by Sales Persons in each product category.
Data Field | Expression |
---|---|
First Sold Product | FirstValue([ProductName]) |
Call the CriteriaOperator.RegisterCustomFunction method to register a custom function in your project (see WebForm1.aspx.cs/WebForm1.aspx.vb).
Pivot Grid for WinForms - How to Aggregate Data by the Field's First Value
(you will be redirected to DevExpress.com to submit your response)