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

Trending Arrows need to be added to certain columns

Started by katdbc, 05 Apr 2012 12:40:56 AM

Previous topic - Next topic

katdbc

Hello Ppl,
version: Cognos 10.1.1
db : Relational (DB2)
I have list  report and Certain columns in the report need to have trending arrows based on values from previous month's data.

Something like  arrow upward when current month > previous month and downward arrow when prev month > current month.

Is this possible using the report studio.

Your help will be greatly appreciated.

pricter

Yes it can be done

Create a variable and use it in the "URL Source Variable" property of the image

Lynn

You could also use a conditional style to display one image or the other.

Another nice technique is to embed a microchart in the list. This could show a trend line over a longer period of time than just current and prior month. It is especially nice when seasonality is a factor.