You have a report and would like to understand how the report sorting work. This example will help you to understand how you can adjust the report settings based on your requirements.
In this case, you want to display the Sales Organization, Product Category and Sales Order ID characteristics and the Net Value Key Figure from the have the Sales Order Volume report sorted by the Product Category.
Reproducing the Issue
1. Go to Sales Orders work center.
2. Select Reports view and open the Sales Order Volume report.
3. Add the following to the rows, if not already available, Sales Organization, Product Category and Sales Order ID characteristics and the Net Value Key Figure.
4. You would like to have the report sorted by the Product Category.
In this example, in order to primarily sort by the Product Category, you will need to move the Product Category column to the very left. For example, let's say you want to sort by Product Category then Sales Order ID and Sales Organization you will need to have the report layout as following: 1st column Product category - 2nd column Sales Order ID - 3rd column Sales Organization.
If you click on the Setting - Characteristics - Sorting option you can then choose if you want to sort by the ID or Description.
The primary sorting sequence is set by the drill down displayed in the report. The drill down sets the order of the characteristics displayed in the report.
Key figure sorting overrules any settings for characteristic sorting.
In addition, on the Sorting tab page, you can sort characteristics displayed in rows and columns according to the description or ID in ascending or descending order.
If a characteristic has attributes, you can also sort the characteristic by attribute. The attribute specified does not have to be selected for display. Only if you set an attribute for a characteristic, and want to sort by the attribute, is sorting by attribute taken as sorting.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To