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. You can sort on multiple dimensions within the chart, but you can not sort on dimensions and measures together, and you can only sort on one measure at a time.

Note

When you have multiple dimensions in your chart, you can apply ranking to one dimension and sorting to another.

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 outer dimension only; inner dimensions 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.

In the figure Break Grouping the chart on the left literally sorts the Gross Margin number, not keeping them in their respective Region groupings. But the chart on the right has turned off Break Grouping, so the Gross Margin values are sorted within their Region groupings.

Use advanced and custom sorting

Task 1: Use advanced sorting

Business scenario

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.

Task flow

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

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

Task 2: Use custom sorting

Business scenario

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.

Task flow

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

  • 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).

Use value sorting

Task 1: 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.

Task flow

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

Save progress to your learning plan by logging in or creating an account

Login or Register
Continue to next lesson