How to sort data in grids
In a report grid we can sort rows, columns, and page-by elements. To sort on a single column, simply right-click on the header and select Sort | Ascending or Descending from the context menu that appears. If you want more complex sorting, you can use the Advanced Sorting window.
Getting ready
Prepare a new report with the following objects:
The Country attribute on page-by
The Product Category attribute on rows
The City attribute on rows
The Sum SalesAmount from FactInternetSales metric on columns
Run the report; by default, the cities are ordered alphabetically.
How to do it...
We want to sort the cities in reverse order based on the sales amount inside each category:
Go to the Data | Advanced Sorting menu.
In the Sorting window, the Rows tab is displayed by default, click on the Add button. A new line is added automatically with the leftmost attribute that appears in the grid, in this case Product Category and the sort order is set to Ascending (you may have to enlarge the...
