• Fluent
  • Fluent Dark
  • Bootstrap v5
  • Bootstrap v5 Dark
  • Tailwind CSS
  • Tailwind CSS Dark
  • Material
  • Bootstrap v4
  • High Contrast
Preferences
Theme Selection
Mode Selection
Touch
Mouse
Localization
*Translated by Google Translator.
Currency
Essential Studio
HOME
All Controls

Example of Drill Down in ASP.NET Core 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.