Print Page - Filtering the records by subtotals not equal to 0

Title: Filtering the records by subtotals not equal to 0
Post by: Cognos10x on 13 Mar 2012 10:30:49 AM

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/

Title: Re: Filtering the records by subtotals not equal to 0
Post by: pricter on 14 Mar 2012 06:20:24 PM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Cognos10x on 13 Mar 2012 10:30:49 AM