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
Instead of doing the totals using addcoltotals, you can use the table visualization, format option, summary - Totals-Yes
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..