Creating a qualified SubTotal across many metrics

[jadr]

User has a report that contains two attributes and a LARGE number of metrics (in excess of 50). They want to qualify the report so that records with a quantity equal to zero are filtered out. Normally, I would create a compound object that sums up the individual metrics and qualify it in "Report Limit", but this would be an impractical approach, considering the number of metrics involved.

Doe anyone know of a way to configure a subtotal using the subtotal editor, or some other method?

Thanks,
JD