drillUpCell

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.

Parameters

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: The slice has several measures. The hierarchy is nested in measures. If the `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");