Sort & reorder data
Last updated
Was this helpful?
Reporting & Writeback Matrix Docs
Last updated
Was this helpful?
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.1. To sort a column by ascending or descending, hover over the column header and click on the gripper. Select Sort -> Sort Desc.
1.2. You can see that the column gets sorted and there is an icon to denote the descending sort.
1.3. 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.4. 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.5. You can see that the dropdown column is sorted in ascending order both at the Category and Sub Category levels.
1.6. Sorting based on text and date columns is shown below.
Click the Sort button on the toolbar for advanced sorting options. You can sort your data based on multiple dimensions or measures. Please bear in mind that you can either sort based on row dimensions or based on measures, not both together.
With Inforiver, you can custom-sort rows/columns by simply dragging and dropping to order the categories the way you want.
a) As you hover over a row header, you can see a gripper icon highlighted below. Click, hold and move up or down to reorder.
Reordering is possible only within the same hierarchy level.
b) The rows are reordered.
Similarly, you can reorder columns and measures. Let's reorder the % variance.
a) Click on the column gripper by hovering over the column header.
b) Drag and drop where required. You can see that the measure is reordered as shown below.
c) Another way to reorder columns/measures is through the 'Manage columns' dropdown. Hover over the column/measure you want to reorder and simply drag and drop.
d) Instead, you can also click on the settings icon highlighted.
e) In the manage columns settings panel, hover over the six dots and use it to drag and reorder.
Unlike visual measures, visual columns cannot be re-ordered.
In the next section, we'll cover how to show/hide values, rows, and columns.
