Actions on column headers

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

Select Element

Selects elements for a particular hierarchy.

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.

Expand

Expands a parent element on the columns to display its child elements together with their parent and other elements of the hierarchy.

Click a parent element and select Expand. To hide the child elements of the selected parent, click the parent element and select Collapse.

Note: The expand or collapse options are only available for the Ad-hoc analysis.

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 increasing/decreasing 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.

Remove Ranking

Removes the ranking and shows all filtered data.