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.

Sorting from the column gripper

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

Margin measure sorted in descending order

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.

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.

Sorting non-numeric columns

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

Sorted data for non-numeric fields

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

Sorting based on date field

2. Reordering

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

2.1. Rows

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

Reorder rows

2.2. Columns

Similarly, you can reorder measures. Let's reorder the % variance.

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.

Reordering columns

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.

Re-ordering columns from Manage columns interface

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

Manage Column settings

In the manage columns settings panel, click on the icon and drag to reorder.

Reordering measures from Manage Columns settings

In the next section, we'll cover how to show/hide values, rows, and columns.

Last updated