Example of Grouping in ASP.NET MVC Pivot Table Control
This sample demonstrates grouping dates in year, quarter, month, etc., and number types in ranges like 1–5, 6–10, etc. in row and column headers of the pivot table.
1001-1004 | 1005-1008 | 1009-1010 | Grand Total | |||||
|---|---|---|---|---|---|---|---|---|
Units Sold | Sold Amount | Units Sold | Sold Amount | Units Sold | Sold Amount | Units Sold | Sold Amount | |
2015 | 387 | $5,076 | 387 | $7,749 | 135 | $396 | 909 | $13,221 |
2016 | 784 | $6,512 | 368 | $10,096 | 304 | $896 | 1,456 | $17,504 |
2017 | 172 | $2,256 | 172 | $3,444 | 60 | $176 | 404 | $5,876 |
2018 | 1,225 | $10,771 | 575 | $16,817 | 475 | $1,428 | 2,275 | $29,016 |
Grand Total | 2,568 | $24,615 | 1,502 | $38,106 | 974 | $2,896 | 5,044 | $65,617 |
Properties
|
Group Date by:
|
|
|
Group Product ID by:
|
|
|
|
In this sample, the date type can be separated and showcased individually as year, quarter, month, or day by selecting the appropriate option from the Group Date by drop-down list. Also, numbers can be grouped by entering the appropriate value in the Group Product ID by by giving a range number in the the numeric text box.
Grouping can be applied through code-behind using the
groupSettings object in the pivot table along with the following properties:
name :
|
Specifies the normal field. |
type :
|
Specifies the field type for applying group settings. For example, date-formatted fields should be in "Date" type and number-formatted fields should be in "Number" type. |
groupInterval :
|
Specifies the interval for date fields in years, quarters, months, etc. |
rangeInterval :
|
Specifies the interval value to group the number field. |