Grids
Example of Default Functionalities in ASP.NET Core Pivot Table Control
This sample demonstrates basic rendering of the pivot table with drill-up and drill-down functionality bound to a relational report.
FY 2015 | FY 2016 | FY 2017 | FY 2018 | Grand Total | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
Units Sold | Sold Amount | Units Sold | Sold Amount | Units Sold | Sold Amount | Units Sold | Sold Amount | Units Sold | Sold Amount | |
France | 729 | $1,160,099.5 | 609 | $983,317 | 703 | $1,140,998 | 68 | $108,401.5 | 2109 | $3,392,816 |
Germany | 528 | $845,472 | 667 | $1,067,220 | 579 | $945,569 | 130 | $211,902.5 | 1904 | $3,070,163.5 |
United Kingdom | 782 | $1,263,109.5 | 640 | $1,031,630.5 | 657 | $1,041,050.5 | 161 | $265,366.5 | 2240 | $3,601,157 |
United States | 682 | $1,085,398.5 | 480 | $770,362 | 644 | $1,022,551.5 | 232 | $366,358 | 2038 | $3,244,670 |
Grand Total | 2721 | $4,354,079.5 | 2396 | $3,852,529.5 | 2583 | $4,150,169 | 591 | $952,028.5 | 8291 | $13,308,806.5 |
The pivot table is an easily configurable, presentation-quality business control used for visualizing relational data sources in cross-tabular format. It is displayed with drill-up and drill-down capabilities and allows users to easily aggregate data. Sorting, filtering, and grouping data are also supported.
In this demo, the pivot table is populated with its minimum default settings.