Hi cw_meg01 ,
You can create a custom field for your column and add space symbol before text to change the order. Text sorting will sort space in the first order. You could add several spaces and it will sort the value with the most spaces first.
In your case, only 2 values are on the wrong places: '+150' and '120-149'.
The data in your new field will be like these:
' 1-29' (2 spaces at the beginning), ' 30-59' (2 spaces at the beginning), ' 60-89' (2 spaces at the beginning), ' 90-119' (2 spaces at the beginning), ' 120-149' (1 space at the beginning), '+150'(no space at the beginning).
Then use this column in the pivot.
![]()