Sorting

Let’s show how to sort rows in the table on the following example report:

Filters are turned off. Product subcategories are on the rows, years – on the columns.

Using this example report let’s sort the rows in the table in the descending order of sales in 2017. Press the right mouse button over the CY 2017 column header:

Select “Add Sorting of Rows (Expert Mode)” from the context menu as shown on the picture above. You will get a dialog that looks like the one you were using to create the filter:

Note that the time is already selected correctly (that’s because we called the context menu for the CY 2017 element). Let’s change the sorting order to “Descending” (as in the picture) and leave the field “Save Hierarchy” unchecked. Press OK. You will get the table with the values in the CY 2017 column sorted descending:

Note the “Sorting 1” sign that appeared in the “Sorting” designer on rows. You can perform the same actions with it as you did with the filters: activate, deactivate, edit and remove.

The same sorting can be created easier using one of the quick sorting options. To use it call the context menu for the CY 2017 element and select “Sort Descending (break hierarchy)” from it:

As you could notice, there are 4 options of quick sorting available:

• Ascending, breaking hierarchy;
• Descending, breaking hierarchy;
• Ascending, preserving hierarchy;
• Descending, preserving hierarchy.