SAP Learning Journey

Sorting Data

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

After completing this lesson, you will be able to:

  • Sort data

Sort Dimensions

Sorting is accessed either from the Analysis ribbon or from a context menu.

There are three basic approaches to sorting dimension members:

  • Sort Ascending - Ascending sort by the currently selected dimension’s current member display type
  • Sort Descending - Descending sort by the currently selected dimension’s current member display type
  • More Sort Options - Opens a sort by dialog, allowing you to chose more sophisticated sorting techniques

Sort Measures

You can sort measure data by values. If you have multiple measures in your crosstab and sort the values of one measure (for example, Sales Volume), the other cells in your crosstab are also affected by the sorting.

Sort Data

As an analyst, you want to sort certain data sets using the sort options in Analysis. You need to analyze an InfoProvider from your RWB BW system, instead of from the CIA BW/4HANA system.

Task 1:

ExerciseStart Exercise

Log in to track your progress & complete quizzes