Applies to:Image RemovedKyvos Enterprise  Image RemovedKyvos Cloud (Managed Services on AWS)  Image RemovedKyvos Azure MarketplaceImage RemovedKyvos AWS Marketplace  Image RemovedKyvos Single Node Installation (Kyvos SNI)  Image RemovedKyvos Free (Limited offering for AWS)

...

Kyvos visualization allows you to sort measures and dimensions in a crosstab in multiple ways. The following sections explain these in detail.

Dimension sorting

In a Kyvos visualization crosstab, the dimensions and rows are sorted in the order they are defined in the semantic model, i.e., the natural order of sorting.

• Each dimension is sorted internally in the most common way for that type of data.
• Numbers are sorted numerically, ascending.
• Text is sorted alphabetically, ascending.
• By default, the dimensions followHierarchical Ascending sorting, preserving the natural order of the hierarchy of the members in the semantic model. You can reverse sort this using the Descending option.
• You can also sort the dimensions alphabetically. In this case, all members are sorted alphabetically, breaking the hierarchy.

...

You will see that the Sub_Category members are sorted in an alphabetically ascending manner while following the hierarchy defined in the Category. 

When you apply Alphabetical Ascending sorting, the members break away from their hierarchy and arrange themselves in an alphabetical manner.

...

Measure sorting across dimensions (by breaking hierarchy)

This sorting breaks the hierarchy. With this non-hierarchical ordering, the members are arranged without reference to their position in the hierarchy. Use this option if you want the ascending or descending sorting arrangement not to be restricted within the parent members in the hierarchy. This enables you to analyze the entire data sorted only in ascending or descending manner. This sorting works outside the context of dimension/attribute in view by applying the sorting across dimensions.
When this sorting is applied, the crosstab view would automatically turn into a tabular view by repeating dimension member values for each row. Also, the option to expand a member of a hierarchy and show subtotals should not be visible in this case. Only grand totals can be displayed in case break hierarchy sorting is applied.

You can apply this sorting:

• Without column headers
• With column headers having contextual members

...