Editing grid row data on bind

Editing grid row data on bind

Is it possible to edit each line on a grid as it is binding? I'd like to
sum a series of records and have it display on one line. I'm setting it up
as a multi-sourced table with an inner and outer join. RouteVersion is the
main table with InventDim/InnerJoin and SalesLine/OuterJoin.
My ultimate goal is to Display a line for each Route per site and the
RemainSalesPhysical sum for that Route on each site. Each route is tied
one to one with an Item.
I've tried this through table methods, but since I can't access the
current grid line's fields I don't know the specific route, or site, or
item (depending on what table the method is in).
Maybe I'm going about this the wrong way, does anyone have any suggestions
for me that can put me on the right path?