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

Multiple Criteria for Summary Filter

Started by j4mi3j24, 30 Sep 2016 02:22:21 PM

Previous topic - Next topic

j4mi3j24

Hi,

I'm pretty new to Report Studio and I just can't figure this out!  I'm hoping someone can help!

I'm trying to create a report that only shows the data if the subtotal meets the following criteria:
1) if UOM is CS and QTY is greater than or equal to 35
2) if UOM is YD2 and QTY is greater than or equal to 500
3) if UOM if FT2 and QTY is greater than or equal to 2000
If it doesn't meet any of the 3 criteria, then I don't want to show anything.

Any ideas how I can do this in one report?  I can figure it out if I do 3 separate reports, but who wants to look at 3 separate reports!?

Any help is appreciated.  Thank you! 



bdbits

Assuming a relational data source, since you did not say, create a detail filter.

([UOM]='CS' and [QTY]>=35) or ([UOM]='YD2' and [QTY]>=500) or ([UOM]='FT2' and [QTY]>=2000)

I'd recommend you at least read through the Report Studio User Guide you can get to from the Help menu.