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.
axisName
— String. The level’s axis. It can be either "rows"
or "columns"
.tuple
— Array of strings. 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.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");