I have a cross tab that shows count of repairs by garages, and good/bad service against them.

 

I really want to supress the complete area to only records where the service is bad.  But I want to display the unsupressed count of all jobs against this "Bad" total. Gosh, I'm reading that back and I'm not sure its clear....

 

An example..

 

garage A    10 jobs       8 good          2 bad

 

if I supress to only bad I have

 

Garage A          2 jobs           2 Bad

 

But its all about the proportion of Bad jobs against total..

 

I've simplified it a little here, as I have degress of "Bad" but in essence, this is my dilema. Is it even possible?

 

Thanks everybody :o)