Guys:
Guys:
I have to make a report like this:
ProductsÃ, Ã, (^, 1200), (^, 345)
This would be to indicate that the sales for a product went up/down during a certain time period. Is there a way to achieve this?Ã,Â
Would really appreciate your help.
Thanks
Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã,Â
Found the solution.
plz share ur solution and update the status of the topic as [solved]
srik
Here's the solution:
Made a list report, took out the borders, formatted to look pretty, inserted 'image' as a column, then pointed that image column to read a .gif file which is an arrow and made it a report expression to read an UP arrow if measure is positive (measure is previous column in the list report), DOWN arrow if measure is negative. Those arrows pointing upward/downward (UP/DOWN arrows) are diferent gif files. There are 4 relative time categories as measures and four arrows linked to them.
Sorry cognostechie but I haven't understand how to create this kind of column. Can you re-explain?
Many thanks
you have to create a dataitem with the expression Current_Year - Previous_Year
sign of this dataitem will show the evolution...
if that works you can edit this dataitem with something like this:
if ((current_yer - prev_year)> 0) then
('../images/uparrow.gif')
else
('../images/downarrow.gif')
and you add a column with an image inside (url of image is of course your new dataitem...)
Quote from: nonooo on 08 Feb 2007 06:26:29 AM
you have to create a dataitem with the expression Current_Year - Previous_Year
sign of this dataitem will show the evolution...
if that works you can edit this dataitem with something like this:
if ((current_yer - prev_year)> 0) then
('../images/uparrow.gif')
else
('../images/downarrow.gif')
and you add a column with an image inside (url of image is of course your new dataitem...)
many many thanks for the reply.
bye
Federico