• Material 3
  • Fluent
  • Bootstrap v5
  • Tailwind CSS
  • High Contrast
Preferences
Theme Selection
Theme Modes
Mode Selection
Touch
Mouse
Localization
*Translated by Google Translator.
Currency

Example of Drill Down in ASP.NET MVC Pivot Table Control

This sample demonstrates how to drill down on all headers, column headers only, row headers only, specific field(s), and specific member(s) within the specific field(s).

DEMO
SOURCE
Drill Down:

In this sample, drill down can be performed based on the option selected from the Drill Down dropdown list. The available options are described in detail below.

All headers : Allows to expand all headers of row and column axes in the pivot table. It can be achieved by setting the expandAll property to true in the dataSourceSettings.
Row headers : Allows to expand all row headers in the pivot table. It can be achieved by setting the expandAll property to true for row fields only.
Column headers : Allows to expand all column headers in the pivot table. It can be achieved by setting the expandAll property to true for column fields only.
Specific fields : Allows to expand specific field(s) in the pivot table's row or column axes. It can be achieved by setting the expandAll property for the relevant field(s) in the row and column axes to true.
Specific headers : Allows to expand specific header(s) within the respective field available in the pivot table's row or column axes. It can be achieved by specifying the respective field name and its member(s), aka header name(s), inside the drilledMembers property in the dataSourceSettings.
Transform your ASP.NET MVC web apps today with Syncfusion ASP.NET MVC components
85+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE