Filtering the records by subtotals not equal to 0

[Cognos10x]

 I have a requirement where I have to filter the records with subtotals equals to 0, so when the subtotals =0 then I dont have the records to appear in the report.

so in the DB I am using total <>0, I tried putting after aggregation but still I am getting those records with the subtotals as zero. Am I missing something ?

Here is the link for the report

http://postimage.org/image/i9qmb0kjv/

[pricter]

You can use a summary filter and applying the scope of it on the data item that you mad the groupin in the list