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.
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.
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.