For output cells, Anaplan XL places the selected member for the selected point into the chosen cell. This value can then be used to drive other charts, formulas or grid selections.

In this example, the column member Geography — France is placed in $A$26, and Product Categories — [1] Bikes in $A$27. This value can then be used to drive other charts, formulas, and/or grid selections:

Link To: When a point on the chart is clicked, this range is selected.

Clear cells where no selection is made: The cell is cleared if no row/column is selected.

  • Unique Name: Displays the unique identifier for the selected hierarchy in the selected cell.
  • Caption: Displays a label of caption associated with the hierarchy in the selected cell.