---
title: "Group and Sort"
slug: "group-and-sort"
updated: 2023-07-21T11:25:57Z
published: 2023-07-21T11:25:57Z
canonical: "docs.avontus.com/group-and-sort"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.avontus.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Group and Sort

The **Group and Sort Panel** allows you to quickly apply grouping and sorting to report data.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/76a28724-9828-4a15-8634-a1778f8fec0e.png)

To create a new sorting or grouping criterion, click the **Add a Sort** or **Add a Group** buttons respectively. Then, select the desired data source field in the invoked drop-down list.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/f6a895ed-8f9c-426e-b6c8-6a23d50d750b.png)

After adding the grouping criterion, the Group Header band is automatically created. You can manually specify whether to display the corresponding **Group Header** and **Group Footer** using the **Show Header** and **Show Footer** check boxes.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/05cb26e2-37e6-4dc4-9582-929dc4b473bf.png)

You can choose the sorting mode (ascending or descending) or disable sorting in the **Sort Order** drop-down list.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/e8095f60-58c4-43d7-a4ab-6d1fede2d581.png)

The **Group and Sort Panel** also allows you to change the precedence of multiple grouping and sorting criteria using the **Move Up** and **Move Down** buttons.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/bf99f497-4ede-4a90-a1c3-a8cb2132ecd5.png)

To remove a grouping or sorting criterion, select it and click the **Remove** button.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/2b40fc80-c314-4ff9-83b4-38d3bd602cf2.png)