drillDownCell(axisName: string, tuple: string[], measureName: string, memberName: string)
[starting from version 2.9.6]
Drills down a specific hierarchy level on the grid and charts.
Note To see the drilled-down level, ensure its parent levels are drilled down and its parent nodes are expanded.
| Parameter/Type | Description |
|---|---|
| axisName String | The hierarchy level's axis: rows ("rows") or columns ("columns"). |
| tuple String[] | If the hierarchy is nested in a node, specify unique names of field members that identify the node in the tuple. Otherwise, set this parameter to [].Live example |
| measureName String | Unique name of a measure for which the hierarchy level should be drilled down. Use this property when:
measureName is null, the hierarchy level will be drilled down for all measures in the slice. |
| memberName String | The name of the hierarchy level to drill down. |
1) Drill down a specific hierarchy level:
pivot.drillDownCell("columns", [], null, "2021");
2) Drill down a specific level of a nested hierarchy:
pivot.drillDownCell("rows", ["blue"], null, "USA");
3) Drill down the second hierarchy level:
pivot.drillDownCell("columns", [], null, "geography.[usa].[california]");
4) Drill down a specific hierarchy level for a specific measure:
pivot.drillDownCell("rows", [], "Price", "USA");