Creating a custom hierarchy

You can create a hierarchy using any combination of the available dimensions.

  1. Select the Options gear icon next to the dimension to use as the basis for the hierarchy.
  2. 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).
  3. Add dimensions to the hierarchy in the right pane.
    Tip You can double-click a dimension to move it between the panes.
  4. (Optional) Use the arrows beside the hierarchy list to move a selected dimension up or down in the hierarchy.
  5. 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.