Query with separated ratios

[#1]

Hi Everyone,

I have an issue in the columns of a query, hope you can help me. I don't know if its possible to achieve.

Let's say I have in columns Product category (dimension) and 2 ratios (sales and TIR)

I need that TIR should be at the end of the columns (see attached image please ), but if I put it in the query I have for each category sales and TIR.

Please see attached image

and thanks