Hide a Group of Records based on Criteria?

  • Thread starter Thread starter screenwriter776
  • Start date Start date
S

screenwriter776

Hi, Folks -

I have a sales report grouped by [SalesRep].

Is it possible to hide a SalesRep's header & detail records if his
sum([revenue]) is less than 1% of the report's total revenue?

(I only want reps whose sum([revenue]) > 1% of the report's grand
total.)

Any ideas would be much appreciated!
 
Back
Top