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).
|
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. More information on the drill down can be found in this documentation section.