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 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 up. Use this property when:
measureName is null, the hierarchy level will be drilled up for all measures in the slice. |
| memberName String | The name of the hierarchy level to drill up. |
1) Drill up a specific hierarchy level:
pivot.drillUpCell("columns", [], null, "2021");
2) Drill up a specific level of a nested hierarchy:
pivot.drillUpCell("rows", ["blue"], null, "USA");
3) Drill up the second hierarchy level:
pivot.drillUpCell("columns", [], null, "geography.[usa].[california]");
4) Drill up a specific hierarchy level for a specific measure:
pivot.drillUpCell("rows", [], "Price", "USA");