i have a dbf with 2 field type and qty
type 1 is in
type 2 is out

example
type qty
1 10
2 5
1 5
1 2


and i want my grid to display like following 4 column

type in out balance
1 10 10
2 5 5
1 5 10
1 2 2

anyone know how to do this in foxpro grid ?
if grid can not then any solution to thisplay the grid above ?

thank