Setting headers

Excel > CCH® Tagetik > Design > select form > Matrix > Headers

Edit an individual header of a dimension

  1. In the list of predefined headers, expand the Predefined functions, then expand the desired nodes of headers, then select the desired header.
  2. Click .
  3. (Optional) In the list of defined headers, remove the header initially set by the system (the description of the dimension).

Create multiple headers to be shown on several rows/columns.

  1. In the list of predefined headers, click Predefined functions, then click the desired hierarchy nodes, then select one or more desired headers.
  2. Click .

Create multiple headers to be shown in a single cell.

  1. In the list of predefined headers, click Predefined functions, then click the desired hierarchy nodes, then select one or more desired headers.
  2. Click .

Headers inserted in this way will appear in a single cell, separated by a comma.

Edit the order of multiple headers

  1. In the list of defined headers, select the desired header then click . The multiple header editor will open.
  2. Change the header order.
  3. Click OK.

Create advanced headers

  1. In the list of defined headers, select the desired header then click . The Cell Fields Wizard will open (see).
  2. Set the desired header (see Cell fields).
  3. Click OK.