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:

Caption/Attribute
Value
Ranking

Break Hierarchy

Breaks the hierarchy and sorts the elements regardless of the hierarchy that you sort. The 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 option is automatically enabled and months are listed alphabetically. To list the months in a chronological order, disable the 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.