Need help on summary on this type of data

[mintman]

Hello friends,
I have a data like this

Zone Stat Volume
AUTO 30 100
AUTO 30 100
Auto 65 100
Auto 65 100
Auto 65 50

I am grouping on Zone then Stat, and now my problem isI have to average volume for each stat in this way
AUTO 30 100
AUTO 65 83.3
till here this is fine, Now finally I have to show total volume for each ZONE like below

ZONE VOLUME
AUTO 183.3

Any ideas on this friends?.
Thanks a lot.
M

 

[mintman]

Guys any ideas?

 

[mintman]

Friends I figured out how to do it I combined Fields Zone and stat and did running total on change of field. Thanks all.
M