Business Intelligence with MicroStrategy Cookbook

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:

1. Go to the Data | Advanced Sorting menu.
2. In the Sorting window, ...