Cpmute values in Dataset Table??

[jaawaad]

Does anyone know how i can compute values from dataset table before
assigning datagrid source to it???
My data table looks something like this.

DATE CAT STEP VALUE
01/16/2006 AAA1 50 1
01/16/2006 AAA1 50 1
01/16/2006 AAA1 50 1
01/16/2006 AAA1 50 1
01/16/2006 AAA1 100 2
01/16/2006 AAA1 100 2
01/16/2006 AAA1 100 2
01/16/2006 AAA1 100 2
01/17/2006 BBB1 50 3
01/17/2006 BBB1 50 3
01/17/2006 BBB1 50 3
01/17/2006 BBB1 50 3
01/17/2006 BBB1 100 4
01/17/2006 BBB1 100 4
01/17/2006 BBB1 100 4
01/17/2006 BBB1 100 4

What i want to do is to be able to sum "VALUE" for each step & date.

Final Output:

DATE CAT STEP VALUE
01/16/2006 AAA1 050 4
01/16/2006 AAA1 100 8
01/17/2006 BBB1 050 12
01/17/2006 BBB1 100 16

Thanks for your help!

 

[latin & geek via DotNetMonster.com]

hey... im a beginner too, and this was one of the things i was hunting for.
have you tried the ".expression" property in columns? it is for assigning a
formula to a column.
for adding up, theres "sum(column_name)"

cheers
L&G