Sets hierarchy options for the selected item in the Design Layout window in Excel.
The list of attributes on this tab is controlled by the values set in the Attributes used for grouping grid on the Group tab of the Item Properties dialog box. If the Group tab is disabled, the Hierarchy tab is disabled also. You can enable both tabs by checking the Use Grouping box on the Group tab.
Use Hierarchy
Enables the controls on this tab.
Attribute Name
Lists all of the report attributes from the Group tab.
Hierarchy Level
Specifies the hierarchy level for the attribute. The hierarchy levels are all set initially to Default.
Create a new sheet every time a Level 1 property value changes
Specifies that a new sheet is created in Excel whenever a Level 1 value is changed in the hierarchy.