Sorting on multiple columns
You can sort data by up to three columns. When you sort by multiple columns, you use the Advanced Sort option, shown in Figure 5-6. It is important to understand the order of precedence for a multiple sort action. On Advanced Sort, select the columns on which to sort, in the order in which you want to sort the data. For example, to sort data by country first, and then by customer name within each country, select the columns in that order on Advanced Sort.
How to sort data on multiple columns
Select a second column from the next drop-down list. Choose the sort order.
You can also select a third column on which to sort. Choose OK.
Figure 5-6  

Additional Links:

Copyright Actuate Corporation 2012