/aspnet-pivot-grid-custom-aggregates

Primary LanguageVisual Basic .NETOtherNOASSERTION

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

This example shows how to aggregate data by the field's first value.

Files to look at

Overview

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.

first value function

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).

Documentation

More Examples

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