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.