subtotal display?

[chaze]

Hello!

I need to calculate the subtotal of each column and display at the 1st or last row of the grid.

do you know any convenient way to do it? I am thinking to add extra row the end. however, this mean the grid can't not sort.

any idea will be appreciated!

thanks!
Jim

[steven]

For work around, you need to do a customized sorting.
Make it clearer, for example, you could add an extra field to indicate if it's a subtotal.
When you do a customized sorting, determine if it's a subtotal by that extra field.
See
http://www.sigmawidgets.com/products/sigma_grid2/demos/example_customized_sort.html
to define a sort rule

[chaze]

Hello,

I defined below function for sorting. I am able to freeze the subtotal/average row at bottom.
However, the sorting does not sort correctly.

function sort_fnt(r1,r2){
   if ( r1.ctrlflag1.replace(/^\s+|\s+$/g,"")!="1" )
      return 1;
   else {
      return -1;
   }
}

I tried return 0 on 2nd logic which make sorting not move. I dont want to do the custom sort by subtract on r1/r2 as i need to support all column sorting which means i need to have same number of sort function defined. (eg r1.columnA - r2.columnB ...)

Any help?

Jim

[chaze]

Any help sir?