How can i separate Total row in sorting so Total row will not be taken affect when the sort caret is clicked in the header

[ejmin]

Here are the example images

That is the example output then the second one should not be like this

The TOTAL row goes up got mixed up.

So I just want to sort it from row 1-8 and not include 9 as a Total row

[Vijeta]

Instead of doing the totals using addcoltotals, you can use the table visualization, format option, summary - Totals-Yes

[ejmin]

Yes partially you're right.... but in my case my total row is different I put an equation in some fields so it is not only summation of all rows in one field.... Sorry for my uploaded pic it was not the actual working table I just only post the same issue and I forgot to include that my total row is a bit different..