Report Studio

You can perform advanced sorting in a report. For example, in a list, you can sort columns within groups and change the sort order of columns. In a crosstab, you can sort a row or column by another item, such as Order year by Revenue.

To perform advanced sorting:

1. Click a column.
   In a crosstab, click the row or column for which you want to perform advanced sorting.
2. Click the sort button and click Edit Layout Sorting.
3. To sort a column within a group:
4. In the Groups pane, under the Groups folder, expand the folder of the grouped column  that you want.
5. In the Data Items pane, drag the data items you want to sort to the Sort List folder.
   Note: You can also drag data items from the Detail Sort List folder.
6. Click the sort order button to specify ascending or descending order.

4. To change the sort order of columns, in the Groups pane, change the order of columns in the Sort List folder of a group, or in the Detail Sort List folder.
   Note: Add items to the Detail Sort List folder to sort items that are not groups.
5. If you are sorting a crosstab:
6. From the Data Items pane, drag the item you want to sort on to the Sort List pane.
   
   For example, you have a crosstab with Product line as rows, Order year as columns, and Revenue as the measure. To sort Order year by Revenue, drag Revenue to the Sort List pane.
7. Click the sort order button to specify ascending or descending order.

6. Click OK.

Related Topics:

• Creating a Calculation—How to work with calculations in Report Studio.
• Sorting in Report Studio Reports—How to use basic sorting in Report Studio.
• Working With Data—How to work with your data in Report Studio.
• Summarizing Data—How to summarize your data.

Copyright © 2018 Daptiv Solutions, LLC. All Rights Reserved