drillUpCell(axisName: string, tuple: string[], measureName: string, memberName: string)
[starting from version 2.9.6]
Drills up 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 up a hierarchy level for a specific measure when:
measureName is not defined, the hierarchy level will be drilled up 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 up. |
1) Drill up a specific hierarchy level:
flexmonster.drillUpCell("columns", [], null, "2021");
See the full code on JSFiddle.
2) Drill up a specific level in the nested hierarchy:
flexmonster.drillUpCell("rows", ["blue"], null, "USA");
See a live sample on JSFiddle.
3) Drill up the second hierarchy level:
flexmonster.drillUpCell("columns", [], null, "geography.[usa].[california]");
See the full code on JSFiddle.
4) Drill up a specific hierarchy level for a specific measure:
flexmonster.drillUpCell("rows", [], "Price", "USA");