Print Page - Report not filtering properly on aggregated field

Title: Report not filtering properly on aggregated field
Post by: JohnGoBlue on 11 Nov 2010 11:41:19 AM

Hi,

I have a report with an aggregated (totaled) field. I would like to only show rows that have a least X for the aggregated field. I set my filter to be applied after auto aggregation. For some reason it is showing one row that has a total less than the filter value. What am I missing???

Title: Re: Report not filtering properly on aggregated field
Post by: PSPCognos on 15 Dec 2010 04:48:34 AM

Hi,

im looking for solutions about the same problem.
I would like to show only aggregated value different from zero but the filter not work correctly.

Thanks to all.

Title: Re: Report not filtering properly on aggregated field
Post by: PSPCognos on 15 Dec 2010 05:02:21 AM

There is one very important step wehave forgotten.
Properties of the filter, change from 'before Aggregation' to 'After aggregation'

Thanks and Sorry

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: JohnGoBlue on 11 Nov 2010 11:41:19 AM