Sorting data is ordering values of data fields in a specific direction. You can sort data in a report using various ways, but sometimes you need to transfer sorted data to a report. In this case, you can create the New Data Transformation and based on it create a report.

 

When creating a new data transformation, the values can be:
Sorted in ascending order. In case with row values, the sorting is carried out from A to Z and for numeric values from Smallest to Largest.
Sorted in descending order. In case with row values, the sorting is carried out from Z to A and for numeric values from Largest to Smallest.
No sorting, i.e. they are transferred to a report in the order where they are contained in data sources.
 

Information

 

You should understand, that a data table can contain a nested sorting, i.e. firstly, values are sorted by one field then by another. For example, firstly product categories are sorted then products in each category.

 

 

 
To enable sorting you should:
Click on a field header in the preview;
Select the sorting mode in the field mode: Ascending, Descending, No sorting.
 
Let`s consider the example of sorting data. For example, there are data columns in a new transformation with the names of product categories, a list of products and their prices.
 
 
Sorting by ascending
 
Step 1: Click on a field header in the preview. In this case, you should click on a data field with category names.
 
Step 2: You should select the sorting values direction in the opened menu. For example, select the from A to Z.
 

 

 
Now all categories will be sorted in the direction from A to Z.

 


 
 
Sorting by descending

 

Step 1: You should click on a field header in the preview. For example, click on the data field with category names.
 
Step 2: You should select the direction of sorting values in the opened menu. For example, select the from Z to A.
 

 

 
Now all categories will be sorted in the direction from Z to A.
 


 

 
Sorting data by several fields
 
Step 1: You should click on a field header in the preview. For example, click on data field with category names.
 
Step 2: You should select the direction of sorting value in the opened menu. For example, select the from Z to A.
 
Step 3: You should click on a header of another field in the preview. For example, click on the field with product prices.
 
Step 4: You should select the direction of sorting value in the opened menu. For example, select from the Smallest to Largest.

 

Now, all categories will be sorted in the direction from Z to A, and products in these categories in the direction from the Smallest to Largest.

 

 

Information

 

To enable sorting values, you should click on an element header in the preview and select the No Sorting direction. After that, the values will be displayed in an original order.