How to order with pivot?

When I add an order by on a pivot column, it starts in order, but doesn’t seem to sort correctly the whole way though.

Here’s a video - https://www.loom dot com/share/6b54d72d72a643beb32347e97469f4cf

(Discourse isn’t letting me post a normal link for some reason)

Hi Justin,

You have two order by’s in your query. The pivot column has lower precedence than your normal column. You can change the column preference in the order bys using drag and drop in the order by section. You can check it out here in this recording: Loom | Free Screen & Video Recording Software

Hope this helps.

1 Like

I see, I understand how it works now. Thank you!