Query report sort total not working

Hello,

i just start using Query reports. I create report with order by, and Total row is sorting too. How could i override this?
Thanks in advance.
SELECT *
FROM (select coalesce(dni.item_code, ‘Total’) AS Nacionalnost,
sum(if(month(dn.posting_date) = 1, qty, 0)) AS Jan,
sum(if(month(dn.posting_date) = 2, qty, 0)) AS Feb,
sum(if(month(dn.posting_date) = 3, qty, 0)) AS Mar,
sum(if(month(dn.posting_date) = 4, qty, 0)) AS Apr,
sum(if(month(dn.posting_date) = 5, qty, 0)) AS May,
sum(if(month(dn.posting_date) = 6, qty, 0)) AS Jun,
sum(if(month(dn.posting_date) = 7, qty, 0)) AS Jul,
sum(if(month(dn.posting_date) = 8, qty, 0)) AS Aug,
sum(if(month(dn.posting_date) = 9, qty, 0)) AS Sep,
sum(if(month(dn.posting_date) = 10, qty, 0)) AS Oct,
sum(if(month(dn.posting_date) = 11, qty, 0)) AS Nov,
sum(if(month(dn.posting_date) = 12, qty, 0)) AS Dec,
sum(if(month(dn.posting_date) = 1 or month(dn.posting_date) = 2 or month(dn.posting_date) = 3 or month(dn.posting_date) = 4 or month(dn.posting_date) = 5 or month(dn.posting_date) = 6 or month(dn.posting_date) = 7 or month(dn.posting_date) = 8 or month(dn.posting_date) = 9 or month(dn.posting_date) = 10 or month(dn.posting_date) = 11 or month(dn.posting_date) = 12, 1, 0) * qty) as Ukupno
FROM tabDelivery Note Item dni, tabDelivery Note dn
WHERE dn.name=dni.parent
group by dni.item_code with rollup) t
order by Ukupno desc

;

Unfortunately there is no way to fix it out of the box, you can write JS that will freeze it in the SlickGrid component (if such a feature exists!)

Ok. Thanks for info.