Specifying level-specific formats of data in hyperblocks

You can format the value cell of a hyperblock so that data output is formatted according to its level in the hierarchy. To do this, use the GETLEVEL function.

Place a hyperblock on the spreadsheet, right-click the value cell, and select Conditional Formatting. In the Condition section, select Formula is from the list. The GETLEVEL function has this syntax: 

GETLEVEL(reference of the key output cell)=n

where n is one of the levels of the hierarchy.

Example

To format the data in a hyperblock according to its level in a hierarchy:

  1. Select cells C6:D6 in Design Mode.
  2. Drag a dimension or list from the Database Structure and drop it on cell C6.
  3. A hyperblock is created in cells C6:D6.
  4. Create an OLAP formula in cell D6
  5. Right-click D6 and select Conditional Formatting.
  6. Create a formula condition where the formula is GETLEVEL($C$6)=1.
  7. Create further GETLEVEL conditions for each level of the hierarchy (using the correct level number for each). Apply a different format to each condition.
    In View Mode, data is formatted according to its level in the hierarchy.
    Note: You can format elements, as well as data, according to their level in a hierarchy by specifying a fill style in the Hyperblock Output Properties dialog
Related topics