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.

tagHelper
DrillThrough.cs
<ejs-pivotview id="PivotGrid" height="300" allowDrillThrough="true">
    <e-datasource data="@ViewBag.data" expandAll="false" enableSorting="true">
        <e-formatsettings>
            <e-field name="Amount" format="C0" maximumSignificantDigits="10" minimumSignificantDigits="1" useGrouping="true"></e-field>
        </e-formatsettings>
        <e-rows>
            <e-field name="Country"></e-field>
            <e-field name="Products"></e-field>
        </e-rows>
        <e-columns>
            <e-field name="Year" caption="Production Year"></e-field>
            <e-field name="Quarter"></e-field>
        </e-columns>
        <e-values>
            <e-field name="Sold" caption="Units Sold"></e-field>
            <e-field name="Amount" caption="Sold Amount"></e-field>
        </e-values>
    </e-datasource>
</ejs-pivotview>
public ActionResult Index()
{
    var data = GetPivotData();
    ViewBag.data = data;
    return View();
}