I was able to fix this now using @lauratilton trick with space in front of the string value. I am using Custom SQL on top of BigQuery and have a sort column with numeric values so it was fairly easy to fix using that. I added a column with the follow...

Can confirm that @Shwetakulka issue is with Pivot table and that your suggestion works with "normal" tables but this is for some reason disabled on Pivot tables

Have you been able to fix this? @Carlos_Leon reply has worked in the past but now I have the exact same issue as you @Shwetakulka that you can't add sort fields to the sort selection and instead you only have the field itself and the metric but I'd n...