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.