expandCell

expandCell(axisName: string, tuple: string[], measureName: string)

[starting from version 2.9.6]

Expands a specific node on the grid and charts.

Note To see the expanded node, ensure its parent nodes are expanded.

Parameters

Parameter/Type	Description
axisName String	The node's axis: rows (`"rows"`) or columns (`"columns"`).
tuple String[]	Unique names of field members that identify the node.
measureName String	optional Unique name of a measure for which the node should be expanded. Use this property when both of the following conditions are met: The slice has several measures. The node is nested in measures. If the `measureName` is not specified, the node will be expanded for all measures in the slice.

1) Expand a specific node:

pivot.expandCell("rows", ["Accessories", "Canada"]);

See the full code on JSFiddle.

2) Expand a specific node for a specific measure:

pivot.expandCell("rows", ["Canada"], "Price");