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

How to show measures only for a certain period

Started by SanderH, 25 Jul 2011 06:26:34 AM

Previous topic - Next topic

SanderH

Hi all,

I'm building a report on top of our weekly sales data warehouse. In this datawarehouse we also have monthly forecast data, which is loaded to the 1st day of the month. So when I run my report, the amount of the forecast is displayed in the 1st week, rather than just as the month total. Also, see the green bar in the attachment (fake data).

How can I fix this? Is there a way to set a "filter" so that the Forecast measure is only shown for the total month?

Thanks
Sander