Most of the reports that we require consists of sorted data i.e. ascending order or descending order. Some use cases includes like finding top 10 customers, or last 1 week of data, or could be for any needs. Sorting can be done on any data type like text, number, date, date time etc.
With Helical Insight the sorting of data is quick and easy. Let us quickly check this functionality
![Sorting in Reports with Helical Insight 5.0](https://www.helicalinsight.com/wp-content/uploads/2021/03/Sorting-in-Reports-with-Helical-Insight-1.png)
While creating report, each and every field that you select comes with sorting iron next to the name of the field. In above example we have 3 fields and next to each name there is an icon “” which shows that no sorting is applied on that column. The same can be confirmed with the SQL below
![Sorting in Reports with Helical Insight 5.0](https://www.helicalinsight.com/wp-content/uploads/2021/03/Sorting-in-Reports-with-Helical-Insight-2.png)
- If you click on this icon it will change it to a sorting icon where it shows an arrow from A to Z. This confirms that a sorting is applied to this field with ascending order. Lowest values will be shown first.
- Clicking on it once again, will make the sorting go in reverse direction and it shows an arrow from Z to A. This confirms that a sorting is applied to this field with descending order. Highest values will be shown first.
- If you click it one more time it will remove the sorting from the filed and gives you the first icon again.
All the three icons are shown in the image below
![Sorting in Reports with Helical Insight 5.0](https://www.helicalinsight.com/wp-content/uploads/2021/03/Sorting-in-Reports-with-Helical-Insight-3.png)
If you generate the report again, you will see the sorting gets applied. You will notice that the data gets sorted on ‘destination’ in ascending order and if there are more than one value in destination, each of them is shown in decreasing pattern of ‘sum_travel_cost’ with highest value first.
If you notice the SQL generated, it will show the same thing werein order by clause has got added (refer below snapshot)
![Sorting in Reports with Helical Insight 5.0](https://www.helicalinsight.com/wp-content/uploads/2021/03/Sorting-in-Reports-with-Helical-Insight-4.png)
You can use sorting to your own needs and get the exact data that you need. Empower yourself with Helical Insight 5.0