DevExpress Blazor Pivot Table

DevExpress Blazor Pivot Table allows you to display and analyze multi-dimensional data from an underlying data source.

Key Features

• Group Summaries
• Grand Totals
• Data sorting
• Data grouping
• Data filtering
• Persistent layout
• Templates
• Virtual scrolling
• Keyboard support

Examples

The Pivot Table component requires the following NuGet packages:

• DevExpress.Blazor.PivotTable
• DevExpress.PivotGrid.Core

Install required packages:

dotnet add package DevExpress.Blazor.PivotTable
dotnet add package DevExpress.PivotGrid.Core

Example 1: Bind a Pivot Table to an In-Memory Data Source

<DxPivotTable Data="SalesData">
    <Fields>
        <DxPivotTableField Field="@nameof(Sales.SaleInfo.Region)"
                           Area="@PivotTableArea.Row"
                           AreaIndex="0" />
        <DxPivotTableField Field="@nameof(Sales.SaleInfo.Country)"
                           Area="@PivotTableArea.Row"
                           SortOrder="@PivotTableSortOrder.Descending"
                           AreaIndex="1" />
        <DxPivotTableField Field="@nameof(Sales.SaleInfo.Date)"
                           GroupInterval="@PivotTableGroupInterval.DateYear"
                           Area="@PivotTableArea.Column"
                           AreaIndex="0"
                           Caption="Year" />
        <DxPivotTableField Field="@nameof(Sales.SaleInfo.Date)"
                           GroupInterval="@PivotTableGroupInterval.DateQuarter"
                           Area="@PivotTableArea.Column"
                           AreaIndex="1"
                           Caption="Quarter" />
        <DxPivotTableField Field="@nameof(Sales.SaleInfo.Amount)"
                           SortOrder="@PivotTableSortOrder.Ascending"
                           Area="@PivotTableArea.Data"
                           SummaryType="@PivotTableSummaryType.Sum" />
    </Fields>
</DxPivotTable>

@code {
    IEnumerable<Sales.SaleInfo> SalesData;
    protected override async Task OnInitializedAsync() {
        SalesData = await Sales.GetSalesAsync();
    }
}

Example 2: Filter Data Using Filter Fields

<DxPivotTable Data="@PivotData">
    <Fields>
        @*...*@
        <DxPivotTableField Field="@nameof(VehiclesData.TrademarkItem.Modification)"
                           Area="@PivotTableArea.Filter"/>
        <DxPivotTableField Field="@nameof(VehiclesData.TrademarkItem.BodyStyle)"
                           Name="@BodyStyleName"
                           Area="@PivotTableArea.Filter" />
        <DxPivotTableField Field="@nameof(VehiclesData.TrademarkItem.SalesDate)"
                           GroupInterval="@PivotTableGroupInterval.Date"
                           Name="fieldSalesDate"
                           Area="@PivotTableArea.Filter" />
    </Fields>
</DxPivotTable>

Related Components/Packages

DevExpress.AIIntegration.Blazor.Chat - DevExpress AI-powered Chat.

dotnet add package DevExpress.AIIntegration.Blazor.Chat

DevExpress.Blazor.PdfViewer - DevExpress Blazor PDF Viewer component.

dotnet add package DevExpress.Blazor.PdfViewer

DevExpress.Blazor.RichEdit - DevExpress Blazor Rich Text Editor component.

dotnet add package DevExpress.Blazor.RichEdit

Demos

• DevExpress Blazor Online Demos
• DevExpress Blazor GitHub Demos

GitHub Examples

• Pivot Table - Data binding using Entity Framework Core
• Pivot Table - Export Data to Excel Using Spreadsheet Document APIs

Documentation

• DevExpress Blazor Pivot Table

Evaluation Period, Pricing Options, and Licensing Terms

Whether you own a license or want to start a 30-day evaluation period, download and register your DevExpress license key. To obtain your key, log in to the DevExpress Download Manager. Use your existing DevExpress.com account or create a new account for free. For key registration instructions, see License Key for DevExpress Products.

If you purchase a license after evaluating a product, re-register your updated DevExpress license key to remove evaluation version warnings/messages.

This package is included in the following commercial subscriptions:

• DevExpress ASP.NET and Blazor Subscription
• DevExpress DXperience Subscription
• DevExpress Universal Subscription

See DevExpress Subscriptions & Licensing for subscription comparison tables, purchasing FAQ, and licensing information.

Software Bill of Materials (SBOM)

To access SBOM files for DevExpress packages, see the following article: Software Bill of Materials (SBOM) for DevExpress .NET assemblies/NuGet packages, JavaScript, VCL and other redistributable artifacts.

See Also: Information Security | Security - What You Need to Know

Useful Online Resources

• www.devexpress.com
• DevExpress Support Center
• DevExpress Blogs