Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear team,
please find the attached.
and in that i want to give the color of max 2 of sum(perc) green and min 2 of sum(perc) as red as per the rank.
for example in CA column rank 1&2 should get green and 4&5 should get red like wise for all the columns.
please help
Maybe use a background color attribute expression like
=If(
rank(total if(sum(PERC) <> '0',sum(PERC))) <= 2,LightGreen(),
If(rank(total if(sum(PERC) <> '0',-sum(PERC))) <=2 , lightred())
)
Maybe use a background color attribute expression like
=If(
rank(total if(sum(PERC) <> '0',sum(PERC))) <= 2,LightGreen(),
If(rank(total if(sum(PERC) <> '0',-sum(PERC))) <=2 , lightred())
)
Perfecto stephen.
Thank you.