Suppress groups totaling less than $5,000 1

[loveyoursite]

CRV10. I have a report grouped by employee showing deductions thus far this year. In Group Footer #1 I have a Summary field (Sum of PAYDEDUCTN.DED_AMT) showing the total deductions to date.

I'm suppressing the detail section, and only want the groups to show that have a Sum of PAYDEDUCTN.DED_AMT of greater than or equal to $5,000.00.

I would appreciate any direction on how best to go about this. Thanks!

 

[synapsevampire]

Try:

Report->Selection Formulas->Group

sum({table.PAYDEDUCTN.DED_AMT},{table.empoyee}) >= 5000

-k

 

[loveyoursite]

Excellent. That worked great, thanks so much!