This example shows how to implement custom group intervals in Pivot Grid to group axis values.

• MainWindow.xaml (VB: MainWindow.xaml)
• MainWindow.xaml.cs (VB: MainWindow.xaml.vb)

The Product Groups calculated field is bound to the following expression:

Iif(Substring([fieldProductName], 0, 1) < 'F', 'A-E', Substring([fieldProductName], 0, 1) < 'T', 'F-S', 'T-Z')

The expression groups the Product Name field's values into three large ranges: A-E, F-S, and T-Z according to product's start characters.

Grouping

Pivot Grid for WPF - How to Group Date-Time Values