Trending Arrows need to be added to certain columns

[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.

Thank you

[MFGF]

Yes - definitely possible. If your package is modelled as DMR, it will be much easier to author this report than if your package is modelled as pure relational.

With a DMR package, you can simply code a query calculation to provide the tuple of the measure and the prior month (derived using a lag() function, for example) then compare this with the tuple of the measure and the current month. With a relational package, you will need to add an extra query to retrieve the prior month values and join this to your main query.

Regards,

MF.