Advanced sorting

The Advanced Sorting option provides the capability to sort your data on different columns simultaneously i.e. perform a nested sort. Click on the Advanced button in the sorting interface to open the Advanced sorting window.

Advanced sorting takes precedence over basic sorting. For instance, if you have sorted the data by the variance and then applied advanced sorting on a dimension category, the basic sort will be overridden.

1. Advanced sorting for charts

We can use the advanced sorting option to apply a nested sort on Subcategory in ascending order and Region in descending order.

Advanced sorting for charts

2. Advanced sorting for cards

You can apply nested sorting in the trellis mode as well. The group dimension can also be used as a sorting factor i.e. you can sort the panels. In this example, we have:

• sorted the panels in descending order (based on Month)

• sorted the bars in each chart in ascending order (based on Actuals)

Advanced sorting for cards

3. Advanced sorting for tables

In table mode, you can perform an Excel-like nested sort. We've sorted based on the axis values.

Advanced sorting for tables