Here are the steps to sort a measure column in pivot table.
1) Duplicate your measure column in criteria
2) In the 'fx' window, enter RANK (measure_column)
3) Place this column in the first position of your rows Section of your pivot table. Apply ascending sort order
4) Hide the column
1) Duplicate your measure column in criteria
2) In the 'fx' window, enter RANK (measure_column)
3) Place this column in the first position of your rows Section of your pivot table. Apply ascending sort order
4) Hide the column
