> For the complete documentation index, see [llms.txt](https://docs.inforiver.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.inforiver.com/analytics+/working-with-analytics+/10.-sort-and-reorder-data/advanced-sorting.md). # 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 This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation by asking a question. Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters: ``` GET https://docs.inforiver.com/analytics+/working-with-analytics+/10.-sort-and-reorder-data/advanced-sorting.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case. 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.