Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to highlight min/max values in a straight table for each column.
how can I do it?
Thanks,
Boris
Try a background color expression attribute (on expression tab, open the attributes by clicking on the plus sign next to the expression label), something like
if(rank( EXPRESSION) = 1, lightgreen(),
if(rank( -EXPRESSION) = 1, lightred()
)
Try a background color expression attribute (on expression tab, open the attributes by clicking on the plus sign next to the expression label), something like
if(rank( EXPRESSION) = 1, lightgreen(),
if(rank( -EXPRESSION) = 1, lightred()
)
For Maximum value, results are coming right but to highlight minimum results are not coming.
I am using below expression:
If(rank(Total Salary)=1,Green(), ---Correct
If(rank(-Total Salary)=1,Yellow())) ---Not Correct
Any Help would be appreciated!
Babita
I prefer using a simpler way
if (rank (column(1)) =1, Green()
,if (rank (-column(1)) =1, red()
))
where column(n) is the number of the column, counting measures only.