This document explains how to apply advanced sorting on an attribute without showing the attribute in grid in MicroStrategy Developer.
This document explains how to apply advanced sorting on an attribute without showing the attribute in a grid in Strategy Developer 10.x. Tutorial project is used in the following steps.
Create a report with attribute 'Category', 'Region' and metric 'Revenue'. Run the report, and the result is shown as below.
In the grid, right mouse click 'Region' and choose 'Remove from Grid'.
Go to 'Data -> Advanced sorting' and 'Sorting' window opens. In tab 'Rows', click 'Add' and find 'Region' does not in 'Sort By' drop-down list. By default, candidates for 'Sort By' must be included in the grid. Then click 'Cancel'.
Move 'Region' back to the grid by right mouse click 'Region' in Report Object panel and select 'Add to Rows'.
Go to 'Data -> Advanced sorting' and open the 'Sorting' window again. In tab 'Rows', click 'Add'. Select 'Region' in the 'Sort By' column and 'DESC' in Criteria column. Leave other options as default and click 'OK'.
The report will appear as shown below with 'Region' included in the grid.
Go to 'Grid -> Options'. Choose tab 'Columns and Rows' and in panel 'Columns' click 'Fixed'. Under 'Fixed' button, select 'Region, DESC' in the drop-down list and type value '0' for Pixels setting. Then click 'OK'.
Then the report will still sort by 'Region' attribute without its appearance in the grid.
