Quarter
Example of Drill Through in ASP.NET MVC Pivot Table Control
This sample demonstrates how to obtain a list of raw items for a particular cell using the drill-through option on double-clicking.
FY 2015 | FY 2016 | FY 2017 | FY 2018 | 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 | 5066 | 46939 | $19,097,073.84 | 5248 | 44513 | $19,575,092.52 | 5581 | 48207 | $18,251,898.21 | 1152 | 11516 | $5,553,761.57 | 17047 | 151175 | $62,477,826.14 |
Germany | 5614 | 44154 | $16,903,257.27 | 5523 | 47910 | $18,081,139.06 | 5462 | 47214 | $18,479,733.38 | 1347 | 11419 | $5,042,868.49 | 17946 | 150697 | $58,506,998.2 |
United Kingdom | 2864 | 25457 | $18,197,943.25 | 2991 | 23944 | $15,422,056.5 | 2924 | 25836 | $17,740,233 | 811 | 6375 | $5,236,607.5 | 9590 | 81612 | $56,596,840.25 |
United States | 5171 | 47724 | $16,224,668.54 | 5442 | 47691 | $17,915,993.08 | 4823 | 46602 | $20,120,714.29 | 1199 | 11715 | $4,352,331.85 | 16635 | 153732 | $58,613,707.76 |
Grand Total | 18715 | 164274 | $70,422,942.9 | 19204 | 164058 | $70,994,281.16 | 18790 | 167859 | $74,592,578.88 | 4509 | 41025 | $20,185,569.41 | 61218 | 537216 | $236,195,372.4 |
Field List
All Fields
- Year
- Order Source
- Products
- Product Categories
- Country
- Sold Amount
- Units Sold
- In Stock
Filters
Rows
Columns
Values
In this sample, you can view the raw items of any pivot table cell by double-clicking the cell. The
drill-through dialog holds the row headers, column headers, and values information of the clicked cell.
Initially drill-through information is displayed for bound fields and you can include the remaining raw items
details using the column chooser option in the dialog.
This feature can be enabled by setting the allowDrillThrough as true.