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
After combining 2 Fields, we get the New field like below screen shot.