Adding trending arrows to a crosstab

[danii64]

Hi All,


I have a requirement where i need to add trending arrows based on the data for current month compared to the data of last month.

CASE
WHEN ([Curr_mon]=[Prior_mon])
THEN  ('straight')

WHEN ([Curr_mon]<[Prior_mon])
THEN  ('up')

WHEN ([Curr_mon]>[Prior_mon])
THEN ('Down')

ELSE
END

In place of the text in '' i would like to use the image for corresponding arrows symbol. When i place the above case statement in string variable, it gives parsing error. but the same case statement works fine in my query

When i place the image on crosstab it places the image on all the cells. I have to display the arrows int he same column as curr_mon. im not displaying the prior_mon column. I do have multiple columns in my crosstab.

Any help is great appreciated!

       

[New_Guy]

Hi,
I have done this for up and down arrows based on variable using cell value>0 , cell value <0 and columnnumber(). Placed a table with 3 cells with the measure in one cell and the arrows in the other 2 cells. Try this approach and if it helps. One more way is to use report expression for getting the image dynamically based on the cell value and column number. Check the below links

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014809626

https://www.ibm.com/developerworks/data/library/cognos/page98.html

Good luck
New guy

[AnalyticsWithJay]

Could you post the details of your error? Try providing a string value in your ELSE statement.

Careful with embedding images in data containers if you have a lot of rows, as the size could get big very quickly depending on the number of images rendered.

I commonly leverage Character Map in Windows for displaying such symbols. It saves on space and the report will run faster.