This content has been marked as final. Show 4 replies
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.
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.