Sorting multiple columns in Looker Studio

[vitortaborda]

I want to sort my table in Looker Studio, with a third sorting, I already used the primary sorting and the secondary.
This is what I want to sort. I already sorted the first column, the second, but the third I tried to put numbers before the text to see if the Looker understand, but it interpret in different ways like this:

And then like this:

I personally would like to sort like the last image going crescent.

But I don't know how to do it.

[sam8]

Column sorting in Looker Studio is limited to a primary sort and a secondary sort. I'd recommend submitting a feature request!

[rmgjohn]

The only solution I've found is to create a calculated field and then concat them all together in the order you want and then use that calculated field for your sort.  But it has to appear in the report in order to use it in the sort.  I just smush it of to one side or the other.

[lauratilton]

You can create a calculated field that concats some of your fields together as suggested above and use that as a sort. However, it does NOT need to appear in the table even though you can't add it directly to the sort. You can just go to your Primary or Secondary sort, click "Add Sort" and then "Add Field" and put the name of the sort field in the New Field (like a calculated field, but just the name of the field you want to sort on.)

[rmgjohn]

I just noticed that myself, I see you beat me to it Laura.  Thanks.