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.

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

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.

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

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

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.

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.

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.