Dispalying only result Rows

Hi Guys,

I have a requirement where I need to supress detailed rows. and display only result. it cant be done by taking out drilldown characteristics as formulas goes for a toss.

Let me know a better way to achive it please?

Example

Channel Supervisor Reportees (Reportees > 12)

Nevada Mr Jeremy Davis 5 0

Nevada Mrs Angela Stabb 16 1

Nevada Mr William Jordy 1 0

Nevada Mr Kenneth Organ 12 0

Nevada Mr Peter Hawkins 2 0

Nevada Mr Gerard Williams 1 0

Nevada Mrs Valerie Lauderdale 14 1

Result 51 2

California Mr Geoffrey 1 0

California Mr David Riste 3 0

California Mr Robert 14 1

California Mr David Cooper 4 0

California Mrs Kathryn 3 0

Result 25 1

Texas Mr Henry King 5 0

Texas Mr Geoffrey Jones 13 1

Texas Mr David Davies 3 0

Texas Mr William Thomas 16 1

Result 37 2

I want it to appear as

Channel Reportees (Reportees > 12)

Nevada 60 2

California 25 1

Texas 37 2

Result 122 5

Please Suggest the way to achive this?

Would sure award points for this.

Cheers

Kirk