Actions on axis hierarchies

Hierarchies, which are highlighted in blue, form vertical and horizontal axes of your data table. See Explore your data and Show data.

When you click the blue hierarchy in the data table these actions are available:

Select Elements / Add Elements

You can search for and select elements from the hierarchy that you want to display in your chart or analysis. You can also select additional elements from the same hierarchy. The new elements are added as tuple values.

See Select element.

Select Level

You can select which level of the hierarchy is shown.

For example, All, Years, Quarters, or Months can be selected for the Period hierarchy.

Select Range

With this option, you first select the level and then select two values that define the range to be displayed.

For example, you can select the level as quarter and select to display values from 4th quarter of 2007 to 3rd quarter of 2009 for the Period hierarchy.

Select Attributes

Depending on your data content, you can display multiple attributes, for example, unique ids, code names, or labels that have been translated to other languages.

The attributes are displayed as additional rows or columns, respectively.

Sort Ascending

Sort Descending

Select one of these options to sort a column in increasing or decreasing order, respectively. You can sort any column, including the attribute column.

Break Hierarchy

Enabling this option sorts the elements regardless of the hierarchy of the dimension. The Break Hierarchy option is enabled when you select sorting.

Disable this option if you want to preserve the hierarchy and its levels when sorting the dimension.

For example, you select the Month level in the Period hierarchy and you sort the Period hierarchy in ascending order. As a result, the break hierarchy option is automatically enabled and months are listed alphabetically. To list the months in a chronological order, disable the break hierarchy option.

Aggregation Setting

With this option you can display aggregation calculations. Select one of these aggregation options: None, Sum, Average, Minimum, Maximum. To change the aggregation settings, you can also click on the aggregated row and select a different aggregation option.

Note: The aggregation settings option is only available for the ad-hoc analysis.

Move to Column Axis

Move to Row Axis

If there are multiple hierarchies selected for the row or column axis, you can move any of those hierarchies to the other axis.

Remove

Adds the hierarchy to filters. This option is only available if there are multiple hierarchies selected for the axis.

Swap Table Axes

Exchanges the table axes.

Note: This option is not available in chart and analysis types where a fixed number of columns is required, for example, Single series or Compare against a target chart types.

Ranking

Provides ranking of the data. The ranking options include: None, Top Count, Top Sum, Top Percent, Bottom Count, Bottom Sum, Bottom Percent.

See Ranking.

Remove Ranking

Removes the ranking and shows all filtered data.

Select Display Type

Changes the display type of all elements of a hierarchy. The default display type is the caption. You can replace the caption with an attribute.