Interval Grouping

 
Order Date
Product Name Category Name Country Unit Price Quantity Total
Order Date: 2014 (Count: 405, Sum of Quantity: 9,581, Sum of Total: $226,132.00)
Queso Cabrales Dairy Products France $14.00 12 $168.00
Singaporean Hokkien Fried Mee Grains/Cereals France $10.00 10 $100.00
Mozzarella di Giovanni Dairy Products France $35.00 5 $175.00
Tofu Produce Germany $19.00 9 $171.00
Manjimup Dried Apples Produce Germany $42.00 40 $1,680.00
Jack's New England Clam Chowder Seafood Brazil $8.00 10 $80.00
Manjimup Dried Apples Produce Brazil $42.00 35 $1,470.00
Louisiana Fiery Hot Pepper Sauce Condiments Brazil $17.00 15 $255.00
Gustaf's Knäckebröd Grains/Cereals France $17.00 6 $102.00
Ravioli Angelo Grains/Cereals France $16.00 15 $240.00
Louisiana Fiery Hot Pepper Sauce Condiments France $17.00 20 $340.00
Sir Rodney's Marmalade Confections Belgium $65.00 40 $2,600.00
Geitost Dairy Products Belgium $2.00 25 $50.00
Camembert Pierrot Dairy Products Belgium $27.00 40 $1,080.00
Gorgonzola Telino Dairy Products Brazil $10.00 20 $200.00
Chartreuse verte Beverages Brazil $14.00 42 $588.00
Maxilaku Confections Brazil $16.00 40 $640.00
Guaraná Fantástica Beverages Switzerland $4.00 15 $60.00
Pâté chinois Meat/Poultry Switzerland $19.00 21 $399.00
Data grid with 2158 rows and 6 columns

The DevExpress Blazor Grid supports interval grouping. Interval grouping allows you to group date-time values by year, month or date, or you can group text values by display text or against individual characters. Use the DxGridDataColumn.GroupInterval property to specify how data rows are grouped.

In this demo, the Order Date column uses interval grouping. Data is grouped by year. You also have options to select other group intervals including: Month or Date.