# Sort & reorder data

Inforiver provides the standard sorting options - ascending/descending and A->Z/Z->A for numeric and non-numeric columns such as date, dropdown, text, and more. Custom sorting orders can also be created using the drag-and-drop reorder feature.

## 1. Sorting

**1.1.** To sort a column by ascending or descending, hover over the column header and click on the gripper. Let's select Sort Desc.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FPxLMpEgD4B2SBdic6TqA%2Fimage.png?alt=media&#x26;token=070e4e43-6110-42ba-8740-ed1d946ca156" alt=""><figcaption><p>Sorting from the column gripper</p></figcaption></figure>

**1.2.** You can see that the Margin measure is sorted, and there is an icon to denote the descending sort.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FYFb1olDO6JKFgbHWeQ2X%2Fimage.png?alt=media&#x26;token=5f7585d8-be3e-4ecc-814a-c98cdb42a525" alt=""><figcaption><p>Margin measure sorted in descending order</p></figcaption></figure>

{% hint style="info" %}
To undo the sorting, click **Remove Sort** from the column gripper. Alternatively, you can click the sort icon in the header to remove the sort.
{% endhint %}

**1.3.** Similarly, sorting can also be applied to non-numeric columns. In a later section, we'll be covering how to insert data input columns such as text, dropdown, date, etc.&#x20;

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FsFjdqMvw9HkgxPPYhJn7%2Fimage.png?alt=media&#x26;token=5ffa68cd-b427-4e1c-9e9f-db2a2c69b6b4" alt=""><figcaption><p>Sorting non-numeric columns</p></figcaption></figure>

**1.4.** Notice that the dropdown column is sorted in ascending order.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2F3KiwR5Si6853cX58mLaz%2Fimage.png?alt=media&#x26;token=5cb3febc-25a6-468e-8791-fbf1ad7a05db" alt=""><figcaption><p>Sorted data for non-numeric fields</p></figcaption></figure>

**1.5.** Sorting based on a date column is shown below.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FvBQj0b6hbfsqwVZmdvKl%2Fimage.png?alt=media&#x26;token=1a17d313-6b28-4fbd-99f0-2cd01ecb10ee" alt=""><figcaption><p>Sorting based on date field</p></figcaption></figure>

## 2. Reordering

With Inforiver, you can custom-sort rows/columns by simply dragging and dropping to order the categories the way you want.&#x20;

### 2.1. Rows&#x20;

When you hover over a row header, the row gripper is enabled. Click, hold, and move the gripper up or down to reorder.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FvXC2bUKIPBiMjNMP1dQX%2FUntitled%20Project.gif?alt=media&#x26;token=4f2d165a-1154-4d7a-8e53-4bcf8729419b" alt=""><figcaption><p>Reorder rows</p></figcaption></figure>

### 2.2. Columns

Similarly, you can reorder measures. Let's reorder the % variance.&#x20;

Click on the column gripper by hovering over the column header. Drag and drop to the required position. Notice how the measure is moved to the end of the report.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FT3ib3FzON9gi9hfbwib3%2FUntitled%20Project.gif?alt=media&#x26;token=859b1ead-2a21-4e6f-8d05-8b06c6060e05" alt=""><figcaption><p>Reordering columns</p></figcaption></figure>

Another way to reorder measures is through the **Manage columns** dropdown. Hover over the measure you want to reorder - a hand icon appears. Drag and drop the measure to the desired position.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2F4dgWbkqee4AhKDEp6uG0%2Fimage.png?alt=media&#x26;token=5be63f96-c59c-4d6b-8355-7f6d032cbd86" alt=""><figcaption><p>Re-ordering columns from Manage columns interface</p></figcaption></figure>

A third way to reorder measures is by clicking on the settings icon highlighted.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FttjRYO1Y31yzjmCoGJDt%2Fimage.png?alt=media&#x26;token=c4936b99-a19a-4afe-9550-da5a44b3f485" alt=""><figcaption><p>Manage Column settings</p></figcaption></figure>

In the manage columns settings panel, click on the <img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FCjWvC5Bui90chKa8GOI5%2Fimage.png?alt=media&#x26;token=5fb60972-af8f-4d21-84df-4fa701d3971d" alt="" data-size="line"> icon and drag to reorder.

<figure><img src="https://2428652681-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsB9HAei8v4FfKkH9M4gw%2Fuploads%2FeXlbQkmrPsCrWJ9cdRRB%2Fimage.png?alt=media&#x26;token=a4f5ad8c-db0f-49bc-bf99-8f217523bbaf" alt=""><figcaption><p>Reordering measures from Manage Columns settings</p></figcaption></figure>

In the next section, we'll cover how to [show/hide values, rows, and columns](https://docs.inforiver.com/premium-table/working-with-premium-table/3.-basic-interactions/show-or-hide-values-rows-and-columns).
