Actions on column headers

When you click on a column header, which has gray background, these actions are available:

Zoom In
Displays all children of the selected element, that is the elements and values at the next level down, without displaying the parents.
For example, if you select the Period hierarchy and zoom in the All Years element, the list of years is displayed on the axis. If you zoom in the 2016 element, the list of four quarters of 2016 is displayed.
Zoom Out
Displays the elements that are one level up from the selected element.
Zoom to Level
Displays a selected level below the current element in a hierarchy.
For example, if you click on the 2016 element, select zoom to level, and select the Month level, all 12 months of 2016 are displayed.
Keep This Element Only
Keeps only the selected element.
Remove Element
Removes the column and all corresponding values from the data table.
This option is only available when multiple columns are selected.
Sort Ascending/Descending
Sorts a column in increasingdecreasing order.
Note: Sorting follows these priorities:
  1. Caption/Attribute
  2. Value
  3. Ranking
Break Hierarchy
Breaks the hierarchy and sorts the elements regardless of the hierarchy that you sort. 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 hierarchy.
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.
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.