Filter based on sum of amounts in Footer section

[crystalfun]

I have a report that shows line item detail (Co, Dept, Account, Balance) in the detail section. This data is sorted by Project # (project header section). The Project Footer section displays the Total by Project based on the amounts in the detail section.

I want to filter out projects that have total costs less than $100,000. I have been able to filter out the detail based on this criteria but I need to filter out the detail if the sum of the project is > $100K.

Here is what I have tried:
Filter section =Sum([Balance]) > 100000
and
Filter Section Sum([Balance]) > 100000

I received error messages on both

The first being a missing operator and the second "Cannot have aggreate function in Where clause.

Can I filter the detail based on the total of the Sum and if so...How? Thanks.

 

[LittleSmudge]

Time wasting multi post warning

thread181-555573