I have successfully created a dhtmlxgrid using coldfusion and dynamic xml. At the end of the list, in the last row I am using some mathematical equations to get some calculations done. These work fine. The problem I am having is when I click on the column name which is supposed to sort and it does but I do not want to sort the last row. I want the last row to appear last. Is there anyway I could set the last row not to sort and always be last row?

The only way - use footer instead of normal rows.
( grid.attachFooter, or similar construct in XML - afterInit/command@call )

The latest version supports some base stat calculations in footer.
    dhtmlx.com/docs/products/dhtmlxG … r_num.html

I have the latest version of dhtmlgrid standard ed. Does the attachFooter work on standard edition?

This functionality available only in pro version
In case of standard version you can try to catch onAfterSorting event, and recreate row with totals as last one.