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.
See GETLEVEL.
To format the Key Output cell see this topic:
Place a hyperblock on the spreadsheet, right-click the value cell, and select
. In the Condition section, select 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:
- Select cells C6:D6 in Design Mode.
- Drag a dimension or list from the Database Structure and drop it on cell C6.
- A hyperblock is created in cells C6:D6.
- Create an OLAP formula in cell D6
- Right-click D6 and select .
- Create a formula condition
where the formula is
GETLEVEL($C$6)=1
. - 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