COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: katdbc on 05 Apr 2012 12:40:56 AM

Title: Trending Arrows need to be added to certain columns
Post by: katdbc on 05 Apr 2012 12:40:56 AM
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.
Title: Re: Trending Arrows need to be added to certain columns
Post by: pricter on 05 Apr 2012 04:09:47 AM
Yes it can be done

Create a variable and use it in the "URL Source Variable" property of the image
Title: Re: Trending Arrows need to be added to certain columns
Post by: Lynn on 05 Apr 2012 08:43:38 AM
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.