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.
| Parameter/Type | Description |
|---|---|
|
axisName String |
The level's axis. It can be either "rows" or "columns". |
|
tuple String[] |
The tuple is needed if the hierarchy is nested in another hierarchy. It consists of member unique names that identify the hierarchy’s parent node. See an example on JSFiddle. |
|
measureName String |
The measure's unique name. Use the measureName to drill down a hierarchy level for a specific measure when:
measureName is not defined, the hierarchy level will be drilled down for all measures in the slice.If the slice contains only one measure, set the measureName to null. |
|
memberName String |
The name of the hierarchy level to drill down. |
1) Drill down a specific hierarchy level:
flexmonster.drillDownCell("columns", [], null, "2021");
See the full code on JSFiddle.
2) Drill down a specific level in the nested hierarchy:
flexmonster.drillDownCell("rows", ["blue"], null, "USA");
See the full code on JSFiddle.
3) Drill down the second hierarchy level:
flexmonster.drillDownCell("columns", [], null, "geography.[usa].[california]");
See the full code on JSFiddle.
4) Drill down a specific hierarchy level for a specific measure:
flexmonster.drillDownCell("rows", [], "Price", "USA");