In this blog post, you will be able to learn how to create ascending and descending sorting in Jedox based on the data value. This type of sorting is very valuable in cases when the end-users would like to make an analysis based on the best, worst-performing product, country, or customer. It can be combined with a top 10 analysis as well. This type of report we already covered in this post.

As you are probably guessing, we will be heavily relying on the subset for this example. Our goal will be to create a report where the same data can be sorted based on 3 measures (Sales, Cost of Sales and Units). Ascending and Descending sorting will be based on countries. Like always, Biker’s best will be our testing database.

subset sorting measures

In our subset, we can see that sorting will be using PALO.D and there we will read from the orders cube. Only 10 countries will be selected and in the sort tab we will choose “Value”. Parents below children will be the variable. This variable will be triggered by the image which is showing ⬆️ ⬇️ simultaneously.

 

Whenever we click on the arrow for a specific measure, data will be framed and sorted accordingly. Arrows are images that have hyperlinks as a backend formula. There are graphs included and they are changing dynamically based on the measure selected.

The full report can be downloaded from here including the Biker database.