I think the combined field method you described is probably
the typical way to approach this problem.
Another method is to:
-drag a second copy of your AGG(CHG) field to the Rows shelf
-edit in shelf and add a negative sign in front of it
-change it to discrete
-move it to the first position after the rank pill
Both methods will require the use of a calculated field
with "Show Header" that needs to be unchecked.
The second method has the benefit that you don't need to set
any sort settings
Please see the workbook v10.3 attached in the Forum Thread.
284989sort.twbx 1.3 MB