Archive

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
Path Finder

Here are the example images
alt text

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

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

Tags (1)
0 Karma

Vijeta
Influencer

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

0 Karma

ejmin
Path Finder

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..

0 Karma