If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report not filtering properly on aggregated field

Started by JohnGoBlue, 11 Nov 2010 11:41:19 AM

Previous topic - Next topic

JohnGoBlue

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???

PSPCognos

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.

PSPCognos

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

Thanks and Sorry