This example shows how to aggregate data by the field's first value in the Pivot Grid control. - View it on GitHub