This sample demonstrates ordering used-defined member(s), aka header name(s), of specific field in row and column axes in ascending or descending order.
FY 2017 | FY 2018 | FY 2015 | FY 2016 | Grand Total | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
In Stock | Units Sold | Sold Amount | In Stock | Units Sold | Sold Amount | In Stock | Units Sold | Sold Amount | In Stock | Units Sold | Sold Amount | In Stock | Units Sold | Sold Amount | |
France | 5581 | 48207 | $18,251,898 | 1152 | 11516 | $5,553,762 | 5066 | 46939 | $19,097,074 | 5248 | 44513 | $19,575,093 | 17047 | 151175 | $62,477,826 |
United States | 4823 | 46602 | $20,120,714 | 1199 | 11715 | $4,352,332 | 5171 | 47724 | $16,224,669 | 5442 | 47691 | $17,915,993 | 16635 | 153732 | $58,613,708 |
Germany | 5462 | 47214 | $18,479,733 | 1347 | 11419 | $5,042,868 | 5614 | 44154 | $16,903,257 | 5523 | 47910 | $18,081,139 | 17946 | 150697 | $58,506,998 |
Bottles and Cages | 345 | 3207 | $25,139 | 110 | 1210 | $9,516 | 372 | 2919 | $23,019 | 437 | 4078 | $31,846 | 1264 | 11414 | $89,521 |
Gloves | 349 | 2834 | $19,397 | 122 | 901 | $6,053 | 411 | 3300 | $22,421 | 377 | 3423 | $23,177 | 1259 | 10458 | $71,048 |
Hydration Packs | 465 | 4358 | $133,745 | 140 | 689 | $21,015 | 397 | 3913 | $119,990 | 368 | 4458 | $136,729 | 1370 | 13418 | $411,479 |
Fenders | 373 | 3528 | $40,255 | 72 | 1236 | $14,094 | 568 | 3064 | $34,870 | 495 | 3068 | $35,113 | 1508 | 10896 | $124,332 |
Cleaners | 366 | 3023 | $13,480 | 72 | 932 | $3,969 | 537 | 3878 | $17,038 | 368 | 4318 | $18,687 | 1343 | 12151 | $53,173 |
Helmets | 396 | 4096 | $64,072 | 112 | 733 | $11,450 | 402 | 4259 | $66,597 | 421 | 3477 | $54,604 | 1331 | 12565 | $196,722 |
Tires and Tubes | 532 | 3306 | $64,205 | 66 | 765 | $14,920 | 455 | 4023 | $78,172 | 384 | 3861 | $74,971 | 1437 | 11955 | $232,268 |
Road Bikes | 435 | 3516 | $5,302,984 | 142 | 1086 | $1,726,869 | 398 | 3439 | $5,438,092 | 442 | 3551 | $5,249,868 | 1417 | 11592 | $17,717,813 |
Touring Bikes | 420 | 4070 | $6,493,071 | 72 | 1032 | $1,646,377 | 467 | 2519 | $4,019,041 | 458 | 3369 | $5,374,835 | 1417 | 10990 | $17,533,323 |
Mountain Bikes | 482 | 3416 | $5,820,656 | 107 | 870 | $1,482,633 | 504 | 3910 | $6,665,094 | 399 | 3908 | $6,658,933 | 1492 | 12104 | $20,627,316 |
Jerseys | 468 | 4253 | $120,585 | 102 | 470 | $13,442 | 328 | 2796 | $79,502 | 422 | 4202 | $119,488 | 1320 | 11721 | $333,016 |
Shorts | 422 | 3898 | $65,187 | 118 | 711 | $12,111 | 333 | 2380 | $40,043 | 453 | 2875 | $47,690 | 1326 | 9864 | $165,031 |
Vests | 409 | 3709 | $316,958 | 112 | 784 | $80,421 | 442 | 3754 | $299,379 | 499 | 3322 | $255,199 | 1462 | 11569 | $951,957 |
United Kingdom | 2924 | 25836 | $17,740,233 | 811 | 6375 | $5,236,608 | 2864 | 25457 | $18,197,943 | 2991 | 23944 | $15,422,057 | 9590 | 81612 | $56,596,840 |
Grand Total | 18790 | 167859 | $74,592,579 | 4509 | 41025 | $20,185,569 | 18715 | 164274 | $70,422,943 | 19204 | 164058 | $70,994,281 | 61218 | 537216 | $236,195,372 |
|
|
|
|
Field:
|
|
|
Headers:
|
|
|
Order:
|
|
|
|
|
In this sample, any field from the Field dropdown list and its member(s), aka header name(s), from the Headers dropdown list can be ordered ascending or descending. It is possible to achieve this by setting the enableSorting property to true, as well as the field name, sort order, and member(s) (which can be in any order) inside the pivot table's sortSettings property. The dataSourceSettings includes enableSorting and sortSettingsproperties. More information on the custom sorting can be found in this documentation section.