# 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. {% hint style="info" %} 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. {% endhint %} ## 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.

## 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)

## 3. Advanced sorting for tables In table mode, you can perform an Excel-like nested sort. We've sorted based on the axis values.

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.inforiver.com/analytics+/working-with-analytics+/10.-sort-and-reorder-data/advanced-sorting.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.