Search results

Drill Through in ASP.NET Core Pivot Grid control

21 Oct 2021 / 1 minute to read

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

Copied to clipboard
<ejs-pivotview id="PivotGrid" height="300" allowDrillThrough="true">
    <e-datasource data="" expandAll="false" enableSorting="true">
            <e-field name="Amount" format="C0" maximumSignificantDigits="10" minimumSignificantDigits="1" useGrouping="true"></e-field>
            <e-field name="Country"></e-field>
            <e-field name="Products"></e-field>
            <e-field name="Year" caption="Production Year"></e-field>
            <e-field name="Quarter"></e-field>
            <e-field name="Sold" caption="Units Sold"></e-field>
            <e-field name="Amount" caption="Sold Amount"></e-field>
Copied to clipboard
public ActionResult Index()
    var data = GetPivotData(); = data;
    return View();