You can create a hierarchy using any combination of the available
dimensions.
- Select the Options
icon next to the dimension to use as the basis for the hierarchy.
- Select Create a custom hierarchy.
The Create Hierarchy dialog appears. The dimensions available
on the Measures and Dimensions panel are listed in the
left pane. You can enter a search string to find a dimension (for example, the
first letters of a dimension name).
- Add dimensions to the hierarchy in the right pane.
Tip You can double-click a dimension to move it between the panes.
- (Optional) Use the arrows beside the hierarchy list to move a selected dimension up or down
in the hierarchy.
- Enter a name for the hierarchy, and select Create.
The new custom hierarchy appears on the Measures and
Dimensions panel. New columns are created for each level of the
new hierarchy.