My data is as follows
"district" "county" "office" "au_id" "Ver_cod" "amt"
DISTRICT4 BEDFORD DDI6 OFFICE 99995 SSIPP $100
DISTRICT1 ANDERSON CASPER OFFICE 99996 W2TAX $500
DISTRICT1 ANDERSON CASPER OFFICE 99996 EARNS $500
DISTRICT1 ANDERSON CASPER OFFICE 99996 BNKF $500
I have done grouping on district, county, office, au_id. au_id is unique. 99995 has 1 "ver_cod" i.e, SSIPP.And 99996 has 3 "ver_code" W2TAX, EARNS, BNKF. Because "Ver_cod" has different values , all other fields are repeating. The "amt" is with respect to "au_id". I need groupwise total and STATE GRAND TOTAL that need to be placed in the PAGE HEADER.I used RUNNING TOTAL to get groupwise totals. But for the STATE GRAND TOTAL I am getting "1600" instead of "600".
Please advise me to write a FORMULA to get the STATE GRAND TOTAL to keep it in PAGE HEADER.
OR is the data wrong as I wrote a VIEW on Database side.
Thanks. Any help is appreciated