Skip to Content
0
Former Member
Mar 19, 2009 at 09:21 PM

Not able to Summurarize

22 Views

I have the data as follows

"code" "id" "amt"

SSIPP 99995 100

W2TAX 99994 500

PS 99994 500

ES 99994 500

i want to summurise on the field "amt" and get the total 600 with respect to id.

but iam getting 1600. how do i write the formula.

I have to place the grand total 600 in the page header as state grand total.

any help is appreciated.

Thanks.