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

Data for Selected Month and Year

Started by ghook, 08 Oct 2008 02:23:55 PM

Previous topic - Next topic

ghook

Need help, please! :)
I have a report with a prompt to select year and a prompt to select month.  The query is filtered based on the selected year and I can get those numbers in the report.  However, I also want to add another column to the report with data only for the selected month.  The desired result is to see both, values only for the selected month and values only for the selected year in the columns next to each other.  In the rows, I have products.  I can't get the month portion of it.  I've tried to use the filter expression, but was unsuccessful.  Please help :)

the_xxx

CREATE TWO LISTS AND FILTER THEM INDIVIDUALLY....BUT PLACE THE TWO LISTS INSIDE ANOTER LIST AND CREATE MASTER DETAIL RELATIONSHIP SO THAT..THE DESIRED RESULT WILL BE FOR THE PRODUCT ON A SINGLE ROW.

TRY THIS.