1) Based upon Single Column (Such as Sorting on Region. Sorting on City). Note Only single at a time.
2) If you want to Sorting Cities of West in Desc, Cities of Central in Ascending, then we need to select the Region one by one individually on the Work area then Apply the Sorting.
3) The below screen shot is intend to sorting the Report according to "Region' Sales Value".
Defining the Sorting of Region as Sales Volume figures
Regions are in Ascending, Cities are in Descending order as Sales Figures
If we want to Apply sorting using two Fields, We need to combine the Fields like the Below screen shot
After combining 2 Fields, we get the New field like below screen shot.
In the following screen shot, I used the Combined Fields for sorting purpose.