SAP Learning Journey

Sorting Data in Stories

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Apply advanced, custom, and value sorting to stories

Custom and Advanced Sorting

You can sort measures and dimensions in tables and charts in ascending or descending order, or you can set your own custom order for dimensions.

Setting a custom sort order is available only in Edit mode, but once set, it can be applied in View mode.

You can sort on multiple dimensions within the chart, but you cannot sort on dimensions and measures together and you can only sort on one measure at a time. However, when you have multiple dimensions in your chart, you can apply ranking to one dimension and sorting to another.

Sorting

Watch this video to learn how to apply custom and advanced sorting.

Break Grouping

Use Break Grouping when there are multiple dimensions in your chart. If Break Grouping is enabled, the sort will be applied to the selected data on the inner dimension and those dimension members will not remain in their original groupings. If Break Grouping is not enabled, the sort is performed on the outer dimension first and then inner dimensions.

Break Grouping On

In the following figure, the chart literally sorts the Gross Margin values, not keeping them in their respective Region groupings.

Break Grouping Off

In the following figure, the chart has the Break Grouping setting turned off, so the Gross Margin values are sorted within their Region groupings.

Use Advanced and Custom Sorting

Task 1: Use Advanced Sorting

Business Example

You are creating a story and need to use the advance sorting functionality in SAP Analytics Cloud sort the locations based on their relative gross margin values and sort the locations based on their relative sales revenue values.

What skills will you develop in this practice exercise?

In this practice exercise, you will:

  • Sort a measure from highest to lowest value
  • Sort on a measure
ExerciseStart Exercise

Task 2: Use Custom Sorting

Business Example

You have sorted your story data using advanced sorting and now you need to create a custom sort order for the number of orders per reasons for delay.

What skills will you develop in this practice exercise?

In this practice exercise, you will:

  • Change the order of the members by selecting multiple members and sending them to the top of the list
  • Send a member to the bottom of the list
  • Use drag and drop to change the order of the members
ExerciseStart Exercise

Value Sorting

Value sorting is simply sorting on numeric values in a table (such as measures or account values) rather than non-numeric values (such as Product names). However, in a table with dimensions in both Rows and Columns, you can sort either vertically or horizontally.

Use Value Sorting

Business Scenario

You have created a custom sort order for your story data and you need to sort the rows of your story in ascending order based on sales revenue.

What skills will you develop in this practice exercise?

In this practice exercise, you will perform the following tasks using value sorting:

  • Access the Value Sorting page
  • Sort the sales revenue data from lowest to highest
ExerciseStart Exercise

Log in to track your progress & complete quizzes