How to make a HAVING clause in Report Studio

[am65]

I'm trying to make an expense report in Cognos 8.4 Report Studio where only the categories with an aggregated expense of more than 50 euros must be shown. The categories where the expense is 50 euros or less must not be shown in the report. Something like this

Category A 51
Category B 70
Category C 81

I use the following summary filter: Expense > 50

But RS seems to ignore it and anyway shows the following

Category A 51
Category B 70
Category C 81
Category D 50

How can I make this?

[CognosPaul]

Instead of using a summary filter, you can use a detail filter. After you create the filter click on it, in the properties on the bottom LEFT you'll have the option to set it to "After Auto Aggregation". That will change it from a "where" to "having"

edit: When I'm tired I can't tell the difference between left and right.

[am65]

Great, not it works. Thanks

Instead of using a summary filter, you can use a detail filter. After you create the filter click on it, in the properties on the bottom LEFT you'll have the option to set it to "After Auto Aggregation". That will change it from a "where" to "having"

edit: When I'm tired I can't tell the difference between left and right.