Pivot Table Hierarchy Value

The HIERARCHY elements represent dimensions. An element represents both the declarative aspects of the column as well as the data value which is typically defined as an RTL expression.

HIERARCHY elements are child elements of PIVOTTABLE and need to be located before a FACT element containing the measures of the row.  

The HIERARCHY element is part of the Business Graphs group in the Report Designer Tool Box.

Properties

Select the object on the Report Design page to display its properties in the Properties View. You can change the object's default appearance by setting the values of its properties.