How do I reorder the query result ( column interchange ) when I have a sum function in the query?

0
votes

I want to reorder my columns in a query function that has a sum function in it.

https://docs.google.com/spreadsheets/d/1AX6iPfq5v1J-zVQCD6F5V21mwWVYQ8JQFmAHlAJnv3s/edit?usp=sharing

Link attached

1
google-sheets

1 Answers

0
votes

Change your formula to

=QUERY(A1:D12,"select B, SUM(D), C group by B,C order by sum(D) desc label SUM(D) 'SUM'", 1)

and see if that works?