Skip to Content
0
Former Member
Mar 20, 2009 at 02:20 PM

Summary formula

26 Views

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