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