I am trying to display arrows going up and down on values in a report.
Apparently they can be shown to be going up or down compared to the previous
Would anyone know how to do this?
Criteria tab->Column Properties->Conditional Format->Apply condition then hit on OK
-> look for Image in Edit Format wizard
->Click on rectangle box->Choose image and click on OK for 3 times
Appreciate if you mark as correct
Do you want to compare measures in current row and previous rows and show Up arrow if the current row measure value is increased and Down arrow if it has decreased ???
If yes then use
1>MSUM function to get the previous row value. Read this blog http://obiee101.blogspot.in/2009/07/obiee-get-previous-row.html
2>Compare (subtract) previous row value with current value.
3> Use conditional formatting as mentioned by Veera to display arrows.
Thanks very much for your reply. I couldn't get the images to come up. It just kept
saying 'Retrieving images ... please wait', when I clicked on the Images rectangle box.
Any idea why?
Thanks very much for your reply.
In the column formula I put:
2* ("- Basic"."Average TAT Hours Created To Transcribed") - MSUM("- Basic"."Average TAT Hours Created To Transcribed",2)
and got the error:
'A REPORT totalling function must be in a leaf query block. (HY000)'.
I looked up the solution - which was:
'De-select the option Report-Based Total (when applicable) for all
grand totals or subtotals you have applied.'
but I thought that only refers to pivot table totals, and I don't have a pivot table anyway,
so I don't understand what this solution refers to now.
Thanks for any help.