> 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.

<figure><img src="/files/alpikD8eO0KgVTeyBNC3" alt=""><figcaption><p>Advanced sorting for charts</p></figcaption></figure>

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

<figure><img src="/files/ifl3S9vETa1RWXFj4HSU" alt=""><figcaption><p>Advanced sorting for cards</p></figcaption></figure>

## 3. Advanced sorting for tables

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

<figure><img src="/files/muBm8vqkDD7NSbXBK0fK" alt=""><figcaption><p>Advanced sorting for tables</p></figcaption></figure>


---

# 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 dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.inforiver.com/analytics+/working-with-analytics+/10.-sort-and-reorder-data/advanced-sorting.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.