Search results

Drill Through

Allows you to view the detailed data or an original value of the summarized cell of the pivot table. It can be enabled by setting the allowDrillThrough property to true. By double-clicking any value cell, you can view the detailed report in a new window. In this report, you can get the row and column headers and summary value(measure) of the clicked cell. Also, you can include or exclude the fields available in the data source using the column chooser option. By default, the detailed reports for bound fields will be shown in the pivot report.

razor
DrillThrough.cs
@Html.EJS().PivotView("PivotGrid").Width("100%").Height("300").DataSource(dataSource => dataSource.Data((IEnumerable<object>)ViewBag.Data).ExpandAll(false).EnableSorting(true)
    .FormatSettings(formatsettings => 
    { 
        formatsettings.Name("Amount").Format("C0").MaximumSignificantDigits(10).MinimumSignificantDigits(1).UseGrouping(true).Add(); 
    }).Rows(rows => 
    { 
        rows.Name("Country").Add(); rows.Name("Products").Add(); 
    }).Columns(columns => 
    { 
        columns.Name("Year").Caption("Production Year").Add(); columns.Name("Quarter").Add(); 
    }).Values(values => 
    { 
        values.Name("Sold").Caption("Units Sold").Add(); values.Name("Amount").Caption("Sold Amount").Add(); 
    })).AllowDrillThrough(true).Render()
public ActionResult Index()
{
    var data = GetPivotData();
    ViewBag.data = data;
    return View();
}